Microsoft Office Tutorials and References
In Depth Information
Sheet tab of the Page Setup dialog box
click to display
click to display
row and column
Trouble? If the Page Setup dialog box is in the way, you can move it to another location
in the workbook window, or you can select the range using the Collapse Dialog Box button.
3. Click the Print Preview button, and then click the Next button on the Print Preview tool-
bar to display the second page of the printout. Now the title and two subtitles appear on
this page as well. See Figure 3-38.
Second page of the printout
titles repeat e d
on each page
click to move to
the previous page
4. Click the Print button on the Print Preview toolbar, make sure the settings in the Print dia-
log box are correct, and then click the OK button.
For now, your work is done. When you save the workbook, your printing options are saved
along with the file, so you will not have to re-create the print format in the future.
5. Save your changes to the workbook, and then close it.
Note that the Sheet tab also provides other options, such as the ability to print the
worksheet’s gridlines or row and column headings. You can also have Excel print the
worksheet in black and white or draft quality. If there are multiple pages in the printout,
you can indicate whether the pages should be ordered going down the worksheet first and
then across, or across first and then down.
You show the final version of the workbook and the printout to Joan. She is very happy
with the way in which you have formatted her report. She will spend some time going over
the printout and will get back to you with any further changes she wants you to make.