Microsoft Office Tutorials and References
In Depth Information
Printing the Gridlines and Headings
Click OK again and the date header will be incorporated into the
printout.
Insert File Path: This lists both the workbook name and the folder(s) in
which the workbook has been saved (e.g.,
C:\Users\Abbott\Documents\PivotTables
). This option is widely used
in the corporate world, because it informs viewers of the workbook
where it is stored in a network.
Insert File Name: This just prints the name of the workbook (e.g.,
PivotTables).
Insert Sheet Name: This prints the name of the worksheet whose data is
being printed (e.g., Sheet1, or any customized name).
Insert Picture: A rather exotic option, this lets you position a photo or
clip art in the header/footer, such as a company logo. The dimmed
button to its right is Format Picture, which contains options enabling you
to modify that picture.
Printing the Gridlines and Headings
Another pair of options you’ll find in the print repertoire let you print both the gridlines
that border every cell in the worksheet and the row and column headings themselves—
the actual numbers and letters that identify cells by their addresses.
Both are easy to do, and the options are alongside one
another in the Sheet Options button group on the Page
Layout contextual tab (see Figure 10–51).
Figure 10–51. The Print Gridlines and
Headings options
Checking the Print box of the Gridlines option will print the lines around every cell selected
for printing. This option is not identical to drawing lines around cells with the Borders
command in the Font button group. That latter option allows you to select exactly those
cells around which you want to see borders. Print Gridlines, however, will automatically
print gridlines around all the cells in your printout.
Thus, if you select the range to print shown in Figure 10–52 and click the Print box of the
Gridlines button, the results will look like Figure 10–53.
Figure 10–52. Six cells selected for printing
 
Search JabSto ::




Custom Search