![]() The same principle applies to “Columns to repeat at left”.Excel spreadsheets that were created by or edited by other people can often have formatting that is not immediately visible when you first view the document. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |