The same principle applies to “Columns to repeat at left”.31. To take that example to the extreme, if you selected row 500 at “Rows to repeat at top” it would not begin repeating until the page after the page that row 500 naturally prints on. If you select rows 4 and 5 as “Rows to repeat at top” page 1 will still print as it appears on screen but beginning with page 2, only rows 4 and 5 (not 1-3) will appear at the top of each printed page. Let’s say you have a report heading in rows 1 through 3 and column headings in rows 4 and 5. The rows you selected don’t have to be at the top of your worksheet – i.e. Also, you only select entire rows (or columns) to repeat. The rows (or columns) to repeat have to be adjacent, for example you can’t select rows 1 and 3, but not 2. To get one or more columns to print on the left side of each page, click in the Columns to repeat at left box, then click on the column or columns you want to have printed on each page.You can select multiple rows by clicking on the first row and dragging to select a range of rows. Then, with the Page Setup window still open, click on the row of your choice. To get rows from your spreadsheet to appear at the top of every printed page, click in the Rows to repeat at top box.
0 kommentar(er)
