I have an Excel worksheet that I changed in Page Setup to be 1 page wide and 40 pages tall. After doing this, the worksheet is exactly 1 x 40. Then, after I try to clean up the look a bit by moving some of the page breaks, it keeps reverting to a 1 page wide, 8 page tall format. How do I get it to STAY at the 1x40 Fit-To option?
I'm sorry I can't provide a dummy file this time around.
Thanks in advance,
Keith
You could record a macro of you adjusting the page setup the way you want it. Then run the macro after you clean up the file.
hi Keith,
What are the rules you apply when you manually put the page breaks where you want them the be?
Edit: for example, do you put a page break after every x rows, or do you put a page break after the end of each "block" of data?
Rob
Last edited by broro183; 03-10-2010 at 11:51 AM. Reason: fix typo & another question
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks