Using the Page Setup Dialog Box

In Excel page setup options can help you make your worksheet look more professional. Learn all about using the page setup feature in Excel here.

Placeholders in the Header/Footer dialog box

In the Header/Footer dialog box, there are a series of placeholder buttons you can ignore or use to format text, insert page numbers, date, time, file name, and tab name.

Placeholder buttons

To insert a page number, date, time, file name, or tab name, position the insertion point in the appropriate text box, then choose the appropriate button.

When the file is printed, Excel will replace placeholders with those you selected. Click OK to return to the Page Setup dialog box.

Select text and click the Font button to format header and footer text. Click OK to return to the Page Setup dialog box.

Button
Button Name
Function of Placeholder
Page Number
Page Number
Current page number
Total Pages
Total Pages
Total pages printed
Date
Date
Date worksheet printed
Time
Time
Time worksheet printed
File Name
File Name
Name of workbook
Tab
Tab
Name of worksheet