Microsoft Office Tutorials and References
In Depth Information
Printing parts of worksheets
On the Sheet page of the Page Setup dialog box, you can use the commands in the Print
Titles area to select the rows or columns to repeat. To choose rows to repeat at the top of
the page, click the Collapse Dialog button next to the Rows To Repeat At Top box, select
the rows, and then click the Expand Dialog button. The rows you selected appear in the
Rows To Repeat At Top box.
Similarly, to have a set of columns appear at the left of every printed page, click the Collapse
Dialog button next to the Columns To Repeat At Left box, select the columns, and then click
the Expand Dialog button. When you’re done, click OK to accept the settings.
In this exercise, you’ll select certain pages of a worksheet to print, have Excel fit your printed
worksheet on a set number of pages, define a multi-region print area, center the printed
material on the page, and repeat columns at the left edge of each printed page.
SET UP You need the HourlyPickups workbook located in the Chapter11 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
On the Page Layout tab, in the Page Setup group, click Print Titles to open the Page
Setup dialog box with the Sheet page displayed.
At the right edge of the Columns to repeat at left field, click the Collapse Dialog
button to collapse the dialog box.
Select the column A header, and drag to select the column B header. The reference
$A:$B appears in the Columns To Repeat At Left field.
At the right edge of the Columns to repeat at left field, click the Expand Dialog
button to expand the dialog box.
Click Print Preview to display your worksheet in the Backstage view.
TIP Even though nothing in the preview indicates that columns A and B will
appear on every printed page, scrolling through the preview shows those
columns on each page.