Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
Formating text columns layout with page breaks in Excel 97 | New Users to Excel | |||
Ignore page breaks for hidden rows | Excel Discussion (Misc queries) | |||
How do I get rid of auto pg breaks in doc with hidden rows in Exce | Excel Discussion (Misc queries) | |||
Pages hidden with manual breaks still print | Excel Discussion (Misc queries) |