Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How Add a Header or Footer to a Worksheet in Excel 2013

In this video you’ll learn how to add headers and footers to Excel worksheets. This is a useful tool if you want to add a large title outside of your table that is repeated on each page. You can use headers and footers to add information to the top or the bottom of your worksheet. This could be the title of the worksheet, your name or that of your business or any other data, such as the date and time.

To add a header, first, go to the ribbon and click on the View tab.
Click Page Layout.
Click to add header.
Click on the header.
Click on Design.
Choose the contents of your header: current date, current time, file name, sheet name, and so on. In this case, we’ll add page numbers.
Headers and footers are broken into three sections so you can have a header or footer that appears in the centre, left or right. Let’s pick a header that appears in the centre.
Excel also allows you to choose different headers and footers for off and even pages. If you want to use this function,
Go back to the Design tab,
Click options and choose what you would like to do.
To add a footer, follow the same steps,
But when you go to Page Layout,
Choose to add footer.
To return to Normal view,
Go back to the View tab
And click Normal.