Microsoft Office Tutorials and References
In Depth Information
SET UP You need the HourlyPickups_start workbook located in your Chapter11
practice file folder to complete this exercise. Open the HourlyPickups_start
workbook, and save it as HourlyPickups . Then follow the steps.
1. On the Page Layout tab, in the Page Setup group, click Print Titles .
The Page Setup dialog box opens, displaying the Sheet page.
2. At the right edge of the Columns to repeat at left field, click the Collapse Dialog
The dialog box collapses.
3. Select the column header of column A , and drag to select the column header of
column B , too.
The reference $A:$B appears in the Columns To Repeat At Left field.
4. At the right edge of the Columns to repeat at left field, click the Expand Dialog
The dialog box expands.
5. Click Print Preview .
Excel displays your worksheet in the Backstage view, which includes a preview of
how your worksheet will appear when printed.