Category Archives: Excel English 2013

Delete Multiple Blank Rows and Columns in Excel 13

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.

Right Click - Delete

Read the rest of this entry

Advertisements

Customize Status Bar in Excel 13

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.

Status Bar

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.

Customize Status Bar

Read the rest of this entry

Predefined Headers & Footers in Excel 2013

As mentioned in my previous posts Header and Footer dialog box and Header And Footer using Page Layout View in Excel 13, I have defined what are Headers and Footers and how to create them using the dialog box and in the Page Layout View in Excel 13. In this post, I will describe how to use the Predefined Headers and Footers.

First of all we must select the Insert tab and then from the left of the ribbon we locate the area named Text as shown in the image below.

Insert - Text

Once we locate the area, we select the Text command where the drop down menu appears with all the available commands. From the drop down menu we select the command Header & Footer.

Header and Footer

Read the rest of this entry

Header And Footer using Page Layout View

As mentioned in my previous post Header and Footer Dialog box Excel 13, I have defined what are Headers and Footers and how to create them using the dialog box in Excel 13. In this post, I will describe how to create Headers and Footers using the Page Layout View.

First of all we must select the View tab and then from the left area of the ribbon named Workbook Views, we select the command Page Layout View as shown in the image below.

Workbook Views - Page Layout

Read the rest of this entry

Header and Footer Dialog box Excel 13

Headers and Footers are text that are printed on the top margins and bottom margins of a spreadsheet. Headers and Footers can contain titles, dates, page numbers and even can contain graphics. We can specify a different Header or Footer for Odd and Even pages or even use a different Header or Footer for the first page.

As mentioned above Headers are printed on the top margin of the page and Footers are printed on the bottom margin of the page. Headers and Footers are the same for all of Microsoft applications.

There are many ways to create Headers and Footers in Excel 13. In the post described below, we will create Headers and Footers with the Header and Footer dialog box. All we have to do is to follow the steps below.

We must select the Page Layout tab and then from the area of the ribbon named Page Setup, we select the arrow, which is located at the bottom right corner of the Page Setup area as shown in the image below.

Page Layout - Page Setup

Read the rest of this entry

Print Titles in Excel 13

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.

Page Layout - Print Tiles

Read the rest of this entry

Paper Sizes in Excel 13

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:

  • Letter
  • Tabloid
  • Legal
  • Executive
  • A3
  • A4
  • B4
  • B5
  • Envelope #10
  • Envelope Monarch

At the bottom of the drop down menu we can select the command More Paper Sizes as shown in the image below.

Page Layout - Size

Read the rest of this entry

Changing Margins in Excel 13

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:

  • Normal
  • Wide
  • Narrow

Read the rest of this entry

Hide & Unhide Sheets in Excel 13

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.

Hide Sheet

Read the rest of this entry

Hide – Unhide Rows & Columns in Excel 13

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?

List Of Names

Read the rest of this entry

%d bloggers like this: