Hi,
I have an excel file I cannot fix. Here's the issue. There are two tabs on the file. First tab I have selected landscape orientation but it shows as portrait both on screen and in print. Also I cannot remove page breaks, so what should be printing as two pages in landscape mode is printing six pages in portrait mode. I have tried several times removing page breaks to no avail.
The second workbook is even worse. I have the same issue with selecting landscape but it will not change in print preview or in print. Worse yet is the page breaks. There are page breaks all over the place and what should print as two pages in landscape is printing on over 153 pages due to all the page breaks.
Everything looks ok in the normal view, but page layout view and page break preview is all messed up.
Help.
Brian
Need help with page breaks and orientation
-
- NewLounger
- Posts: 8
- Joined: 26 Oct 2010, 12:34
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Need help with page breaks and orientation
Could you attach a copy of one of the workbooks to a reply? You can clear all proprietary or sensitive information from the copy.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 392
- Joined: 25 Jan 2010, 12:21
Re: Need help with page breaks and orientation
Cross-posted at http://windowssecrets.com/forums/showth ... rientation" onclick="window.open(this.href);return false;
Steve
Steve