Note
2020 January Edition 2020.1.1 and newer
This topic includes information about tech pack output in the Excel format.
If you print the Excel version of the tech pack, for some of the worksheets you may find the content easier to follow if you ensure the column and row labels are repeated on every page. You may also want to set up your own page breaks.
Column and Row Labels
To format the worksheet output for labels:
-
In Excel, open the worksheet you want to configure.
-
On the Page Layout tab, in the Page Setup group, click Print Titles.
The Page Setup dialog box is displayed with the Sheet tab selected.
-
In Rows to repeat at top, type in the rows that contain the column labels. For example, to print column labels at the top of every page, type $1:$1.
-
In Columns to repeat at left, type in the columns that contain the row labels. For example, to print the row labels of column A at the left side of every page, type $A:$A.
Note
For both Rows to repeat at top and Columns to repeat at left, you can alternatively:
-
Click the
button at the end of the data box and then select the rows or columns you want to use. (The button image may vary depending on the version of Excel you are using.)
-
Click Enter to return to the Page Setup dialog box, then click OK.
Page Break
To insert a page break:
-
In Excel, open the worksheet you want to configure.
-
On the View tab, in the Workbook Views group, click Page Break Preview.
The worksheet displays with a preview of the page breaks.
-
You can insert vertical and horizontal page breaks. To insert a:
-
Vertical page break, select the row below where you want to insert the page break.
-
Horizontal page break, select the column to the right of where you want to insert the page break.
-
-
On the Page Layout tab, in the Page Setup group, click Breaks.
A menu is displayed.
-
Click Insert Page Break. The page break is inserted.
Comments
Please sign in to leave a comment.