ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Repeating rows in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/183108-repeating-rows-excel.html)

Amy

Repeating rows in Excel
 
If you have a repeating row is there a way to turn it off for a specifc page.
Example: If the worksheet requires a header on page 1 through 5, but not
page 6 can it be removed for page 6?

Dave Peterson

Repeating rows in Excel
 
Not really.

Well, you could record a macro that adds the rows to repeat at top and then
prints the pages you want. Then remove the rows to repeat at top and print the
other pages.

Then if you need to do this again, you can just execute your macro.

Amy wrote:

If you have a repeating row is there a way to turn it off for a specifc page.
Example: If the worksheet requires a header on page 1 through 5, but not
page 6 can it be removed for page 6?


--

Dave Peterson


All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com