Category Archives: Excel English 2013
Usually when we have a Worksheet containing a lot of data, we find ourselves to have a lot of empty Rows or Columns in it. What happens if we want to delete these empty Rows or Columns. We can delete the empty Columns or Rows, just by right clicking on the selected Column or Rows and from the shortcut menu that appears we just select the command Delete as shown in the image below. What though if we want to delete multiple empty Columns or Rows?
All we have to do is to follow the steps described below.
In all Microsoft Office programs there is the Status Bar which is located at the bottom of the window. On the Status Bar many options are activated by default, but we also have the option to activate or deactivate commands in order for them to help us. In the image below, we can see the Excel Status Bar with the commands Average, Count and Sum activated.
In order for us to customize the Status Bar, all we have to do is to do a right click on it and from the shortcut menu that appears we just click on the command that we want to activate or deactivate. In the image below we can see how we can customize the Status Bar.
In Excel we are allowed to Print Titles. What does this mean? We can print particular row and column headings on each page of the report. This feature is quite handy, because Print Titles are important in multi-page reports. Why? Because in multi-page reports, the Print Titles always appears on all the pages of the report. The Rows appear at the top of each page, and the Columns appear at the left of each page. This feature will be described below, all you have to do is to follow the steps:
First, we must select the Page Layout tab and then from the area of the ribbon named Page Setup we select the command Print Titles as shown in the image below.
In the previous post of mine, I mentioned how to change the Margins of our Spreadsheet in Excel 13. What happens though when we want to change the Size of our Paper, change the Orientation or even Scale it down in order for it to Fit when we print it? In this post I will describe these features among with others. All you have to do is to follow the steps below:
First of all we must select the Page Layout tab and from the area of the ribbon named Page Setup we select the command Size as shown in the image below.
Once selected the drop down menu appears where we can select one of the predefined Paper Sizes, with their measurements at the side and which some of them are the following:
At the bottom of the drop down menu we can select the command More Paper Sizes as shown in the image below.
In Page Layout view, we can check out the Margins of our Spreadsheet in order to see where the page starts and where it ends. We can also use the Excel Backstage View and the Print Preview on the right side of the Print pane in order to check out the Margins. What happens though when we want to adjust and change the Margins of our Spreadsheet? All we have to do is to follow the steps described below.
First, we must select the Page Layout tab and then from the area of the ribbon named Page Setup we select the Margins command as shown in the image below. Once the Margins command is selected, the drop down menu appears with all the default Margins that we can use. The default Margins that we can use followed by the measurements are the following:
In the previous post of mine, I described how to Hide or Unhide Rows and Columns in Excel 13. In this post, I will describe how to Hide or Unhide Sheets in a Workbook. A feature very handy, which comes useful when we want to make our Workbook less crowdie when it contains many sheets. All we have to do is to follow the steps below.
First, we move over with our mouse over the sheet that we want to hide, and then we do a right click on the sheet. Straight away the shortcut menu appears as shown in the image below, where we select the command Hide.
I believe when working in Excel, we come to the point where we want to Hide a Column or a Row, in order to understand the data in the Worksheet. Sometimes a Worksheet that contains many data is confusing to read and time consuming, so we find ourselves wanting to make our Worksheet less crowdie, but not by deleting the data but hiding some. In this post I will describe how to Hide or Unhide Columns and Rows. All we have to do is to follow the steps below.
In the image below, we can see a table that is created with all the necessary information in it. Now, we assume that we want to hide the Columns B, C, D and E, in order to focus on the rest of the data. What do we do?