Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

page breaks

ResolvedVersion 2003

Denise has attended:
Excel Advanced course

Page Breaks

Unable to remove a page break via the usual method

RE: Page Breaks

Hi Denise,

Thank you for your question and welcome to the forum. If the page breaks have been added manually then the following may help you.

One trick I thought of is to click into a cell underneath the Horizontal Page Break and then choose Insert, Remove Page Break.

If it is a vertical page break click in a cell to the right of the page break and choose Insert and Remove Page Break.

I hope this works.

Let me know.

Regards

Simon

Tue 29 Dec 2009: Automatically marked as resolved.

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.