Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · Medium Priority · Version 2007

Reply 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!

For upcoming training course dates see: Pricing & availability

Reply 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

Regards

Simon

Reply 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?

Reply 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

Reply 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

Excel articles

· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Do You Need To Run Excel 2007 In Compatibility Mode?
· Using Excel In Any Condition
· Some Interesting Finds In Excel 2007/2010 Using Find And Select
· Creating Charts with Excel

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips