Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I do page breaks when view menu doesnt page break preview HeatherF55 Excel Discussion (Misc queries) 0 September 21st 07 04:24 AM
Formating text columns layout with page breaks in Excel 97 Shayne T. New Users to Excel 2 February 2nd 07 02:53 AM
Ignore page breaks for hidden rows T Kirtley Excel Discussion (Misc queries) 1 September 26th 06 06:26 PM
How do I get rid of auto pg breaks in doc with hidden rows in Exce Annie777057 Excel Discussion (Misc queries) 1 July 12th 06 07:57 PM
Pages hidden with manual breaks still print D Poole Excel Discussion (Misc queries) 1 February 10th 06 02:43 PM


All times are GMT +1. The time now is 01:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"