98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Medium Priority · Version 2007
Wed 20 Apr 2011, 12:22Delegate Sachin said...
Sachin has attended:
Excel Intermediate course
Excel VBA Intro Intermediate course
Excel
After going onto page break preview on one of the sheets, the sheet was broken into 6 pages. However, there is one page that I do not want to be printed, but I am unable to remove this page because it will affect the page break sections for another page.
I hope this makes sense!
Wed 20 Apr 2011, 13:31Trainer Simon said...
RE: Excel
Hi Sachin,
Thankyou for your question and welcome to the forum.
Is it possible to send me a copy of the document so I can take a look at it with a full description of what you need to:
sk@stl-training.co.uk
Regards
Simon
Tue 26 Apr 2011, 09:23Delegate Sachin said...
RE: Excel
It's a bit difficult due to sensitive data being displayed.
On one of the excel sheets, I have columns of data. When displaying and editing page breaks, the total number of pages totals 6. However, one of the pages (page 6) does not have any cell entries therefore needs to be removed. However, by altering the page breaks for page 6 will also alter the page breaks for some of the other pages.
Is there a way to remove page 6 without removing any of the other pages?
Wed 18 May 2011, 10:58Trainer Simon said...
RE: Excel
Hi Sachin,
Could you please update me on whether you have resolved your forum post.
In Page Break Preview can you adjust the Used work area(the blue outer rectangle) to cover only pages 1 to 5?
Regards
Simon
Tue 26 Apr 2011, 16:06Trainer Simon said...
RE: Excel
Hi Sachin,
Thank you for the response.
Have you tried selecting from Page 1 to Page 5 in the print dialogue box?
Regards
Simon
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Change the Default Width of All Columns in Excel 2010If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how: |
