Excel Headers and Footers

 in Excel  tagged excel / headers / footers by

This post is about a few suggestions and tips about setting up our headers and footers in your Microsoft Excel workbook. I like to use the custom header and footer.

In Excel, go to Page Layout as shown in the screenshot below. Please click the screenshot to enlarge it.

Click the bottom right corner and then go to the Header/Footer tab. Click the Custom Header button (shown in the screenshot below).

Below is the list of some suggestions for the Left, Center and Right sections of the header and footer. These are from Philip Burton in his Udemy MO-200 video.

  • A list of the…
  • &[Tab]
  • &[Picture]
  • &[Date] &[Time]
  • Page &[Page] of &[Pages]
  • &[File]

With the picture you can create a watermark.