Adding Excel file information to the header and footer

Office 365 / SharePoint Blog

Adding file information to the header and footer of an Excel file can be done as follows:

  • Under the page layout tab
    • click the little arrow under print titles to expand your page setup window
  • Under the header/footer tab, pick custom header or custom footer
    • For each section, click the information you want to show.
    • To figure out what information each option provides, just click on the buttons.
      • In the center section, I added the word “Page” in front of the options
      • In the right section, I added the words “Last printed: ” in front of the date field.

Excel Header and Footer

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s