Repeating Rows and Column on a Print Out
When your Excel table spans more than one printed page, you can repeat the rows or columns (that serve as headings) on the subsequent printed pages. On this table
I’ve added some manual page breaks to simulate a large table. To show the months across the top of every page and the regions across the left of every page, use the Sheet tab under File > Page Setup.
Page 4 of this print out looks like this without any rows or columns repeating.
And the same page looks like this after the changes to File > Page Setup > Sheet
Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].
Leave a comment