Learn how to customized Header & Footer in printing excel sheet

This time under printing setting we will talk about headers and footers. Specially customized
header and footer.

Let me go to page layout. Under which let me click on the small icon which will lead me to page setup.

Small Icon-Page Setup

Let me now access the tab of header & footer.

Page Setup-Header&Footer

Now there are some predefined templates of header. So one of them says page 1 of 10. The question mark stands for the number of pages. So that means if you have 3 pages, the number of pages will define page 1 of 3, page 2 of 3, page 3 of 3.

Page Setup-Select Page

So how do I customize this. Let’s say if I go to custom header. There are couple of icons on the top part of the panel.  If I just hover my cursor on any one of them. Notice its some of them buttons are referring to insert number of pages. Insert datetime, maybe the file pathfile namesheet name and so on so forth. In fact you can also insert a picture, a company logo on the top left or right.

Custom Header

At this moment let’s say I want to place the file name on top. So I click on the file icon
which says insert file name. Then I press a space. And then I say -, this is artificially inserted. And then I say sheet name.

Towards the right hand side. I put the date. Date and the page number, I’ll be using as a footer. So let me not add more elements. Let me press ok.Add-elements-in-header

So towards the end when you take a printout this is how it is going to look like. It’s going to talk about the file name, the sheet name and the date.

Page Setup-File Name

Let me now go to custom footer. Here let me add the word page. And then let me click on this icon which says insert page number. So page X that means page 1 of which page.

Then you will click on the button which will say total number of pages. Insert number of pages. So as I press ok.

Footer Selections

Notice the preview will say something like this. Page 1 of page 5, page 1 of page 6. Depending upon how many number of pages in total there are.

Page Setup-Footer

So if I go to print preview, notice towards the bottom of the panel of the print preview section I have this footer of page 1 of 5, page 2 of 5. It’s very small.

Print Privew 01

In fact, towards the top part of the print paper. You’ll find the file name, the sheet name and the date.

File Name & Date in Prieview

So this is how you get customized the header and footer by going. Inside page setup, header & footer panel and clicking on either of the icons and ensuring that you put the right elements, datetimefile namesheet nameand picture and so on so forth.

I hope you like our blog, do share with your friend and colleague.

More related content available on our YouTube channel: Yoda learning YouTube Channel

Check out our: Premium E-Learning Video Courses

Pre-Registration Open

Power BI Dax

Related Tutorials

Text To Column in Excel | Split Cells
January 4, 2019
Pivot Tables (Complete Guidelines)
December 27, 2018
Power Bi Dax Deduplication Based On Column
December 17, 2018
Special Character Symbol List with Shortcodes in Excel
December 15, 2018
December 10, 2018
December 10, 2018
How to use ABS Function in Excel
December 10, 2018
How to use AND Function in Excel
December 10, 2018
Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018