Header and Footer Toolbar

microsoft excel docs

microsoft excel docsInsert AutoText - Allows you to choose from a variety of preformatted headers and footers.
microsoft excel docsInsert Page Number - Inserts page numbers that automatically update when you add or delete pages.
microsoft excel docsInsert Number of Pages - Prints the total number of pages in the active document by inserting a NUMPAGES field at the insertion point.
microsoft excel docsFormat Page Number - Formats the page numbers in the current section.
microsoft excel docsInsert Date - Inserts a date field that automatically updates so that the current date is displayed when you open or print the file.
microsoft excel docsInsert Time - Inserts a time field that automatically updates so that the current time is displayed when you open or print the file.
microsoft excel docsPage Setup - Displays the Layout tab of the (File > Page Setup) dialof box.
microsoft excel docsShow/Hide Document Text - Displays or hides the document text while you work in the header or footer area.
microsoft excel docsSame as Previous - Inserts the header or footer from the previous section in the current section, or creates a different header or footer by breaking the header or footer connection between the two sections.
microsoft excel docsSwitch between Header and Footer - Moves the insertion point between the areas in which you create or change headers and footers.
microsoft excel docsShow Previous - Moves the insertion point to the previous header or footer that is different than the current header or footer.
microsoft excel docsShow Next - Moves the insertion point to the next header or footer that is different than the current header or footer.
microsoft excel docsClose Header and Footer -

Insert AutoText Drop-Down Commands

This drop-down lets you choose from a selection of built-in entries that you may find useful.
These are all inserted as form fields are are updated automatically as the document is edited.

microsoft excel docs

PAGE -
Author, Page #, Date -
Confidential, Page #, Date -
Created by -
Created on -
FileName -
Filename and path -
Last printed -
Last saved by -
Page X of Y -


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext