ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Page Breaks and hidden columns (https://www.excelbanter.com/excel-discussion-misc-queries/180593-page-breaks-hidden-columns.html)

GTCUW

Page Breaks and hidden columns
 
For some reason, when I hide Column A (it seems to be only Column A) and
insert a page break into my document, I get multiple blank pages before what
is suppose to be page 1 of my document. However, if I insert the break before
the hide, no problem.

Does anyone have any ideas how to resolve this problem other than unhiding
Column A before adding a page break?

Pete_UK

Page Breaks and hidden columns
 
It depends how you set the page breaks. If you click on View | Page
Break Preview you will see where the page breaks will occur by means
of the blue horizontal (dotted) lines. You can drag these up to adjust
where they will occur, and this is independent of whether column A is
hidden or not. Click on View | Normal to restore what the screen looks
like.

Hope this helps.

Pete

On Mar 19, 2:50*pm, GTCUW wrote:
For some reason, when I hide Column A (it seems to be only Column A) and
insert a page break into my document, I get multiple blank pages before what
is suppose to be page 1 of my document. However, if I insert the break before
the hide, no problem.

Does anyone have any ideas how to resolve this problem other than unhiding
Column A before adding a page break?




All times are GMT +1. The time now is 07:32 PM.

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