1 Set A Print Area
Set the cells A1 through M17 to be the print area for this worksheet.
- Select cells A1 through M17
- Click the Page Layout tab
- In the Page Setup group, click the Print Area drop-down arrow
- Click Set Print Area
2 Save In Alternative File Formats
Save the current file as a PDF to the GMetrixTemplates folder. Accept the default options for the file name and settings.
- Click the File tab
- Click Save As
- Click Browse
- If necessary, navigate to the GMetrixTemplates folder
- Click the Save as type drop-down arrow
- Click PDF
- Click the Save button
Print Settings
Set the current worksheet to repeat the top two rows and the first column to repeat on every page when the worksheet is being printed.
- Click the Page Layout tab
- In the Page Setup group, click Print Titles
- Click in the Rows to repeat at top field
- In the worksheet select rows 1 and 2
- Click in the Columns to repeat at left field
- In the worksheet select column A
- Click the OK button
Inspect Workbooks
Perform an accessibility check on the current workbook. Rename the first warning instance to January and the second to Forecasting.
- Click the File tab
- Click the Check for Issues drop-down button
- Click Check Accessibility
- In the Accessibility Checker panel expand the Default Sheet Names warning
- Select Sheet1 and then the Sheet1 dropdown
- Under Recommended Actions select Rename Sheet
- Type: January
- Press the Enter key
- Back in the Accessibility Checker panel select Sheet2 and then the Sheet2 dropdown
- Under Recommended Actions select Rename Sheet
- Type: Forecasting
- Press the Enter key