|
.png)
1. Print. Shows the Printer Settings dialog box for the corresponding worksheet.
2. Print Preview. Shows the Print Preview dialog box for the corresponding worksheet, displaying options to print using the current printer settings and zoom to modify the preview extents.
3. Left Header. Text that will be shown in first third of the header extents.
4. Center Header. Text that will be shown at the center of the header extents.
5. Right Header. Text that will be shown in right third of the header extents.
The following codes can be inserted and combined in the header text to show predefined information:
|
Code
|
Action.
|
|
&B
|
Use a bold font.
|
|
&I
|
Use an italic font.
|
|
&U
|
Underline the header.
|
|
&"fontname"
|
Use the specified font.
|
|
&nn
|
Use the specified font size (must be a two-digit number).
|
|
&D
|
Prints the current date.
|
|
&T
|
Prints the current time.
|
|
&F
|
Prints the workbook name.
|
|
&A
|
Prints the worksheet name.
|
|
&P
|
Prints the page number.
|
|
&P+number
|
Prints the page number plus number.
|
|
&P-number
|
Prints the page number minus number.
|
|
&&
|
Prints an ampersand.
|
|
&N
|
Prints the total number of pages in the document.
|
Example format codes inserted between header text:
&BPage &P of &N Summary Totals &D &T
Result when worksheet is printed:
.png)
|