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

Once the Page Layout View is selected we can see the Header on our Workbook Sheet. This area is separated in three different areas. The Left, the Center and the Right area. All we have to do is to click in the area that we want and type in the information needed.

Click To Add Header

In the image below, I have typed in the information needed in the Left, Center and Right area of the Header.


If we scroll down in our Workbook, we will be able to see the Footer area, which is also separated in three different parts, the Left, the Center and then Right, as same as the Header. Here we follow the same procedure as the Header, meaning that we just click in the area that we want and add in our information.

Click To Add Footer

In the image below, we see all the information that I have added in both the Header and Footer areas.

Header and Footer

Below you can check out the video describing how to create Headers and Footers using the Page Layout View in Excel 13.


About Smart Office - philippospan

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on July 14, 2015, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Header And Footer using Page Layout View.

Comments are closed.