Page Break Issue When Inserting Row

khabi21

New Member
Joined
Oct 12, 2016
Messages
35
I have two documents that are very similar. I am working from "Page Break Preview" view so that I can see where the page breaks are.

In one document, when I insert a row above Row 1, the page break shifts down so that the new Row 1 (which was inserted) would not be printed. It is greyed out.

In the other document, when I insert a row above Row 1, the page break stays above Row 1. Therefore, Row 1 would be included when printed.

I cannot for the life of me figure out why this is happening. It is causing an issue with my macro as I use a macro to add headers above Row 1, which are now not being printed.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,012
Office Version
2016
Platform
Windows
.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,509
Messages
5,469,038
Members
406,629
Latest member
Alan365

This Week's Hot Topics

Top