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

print preview

ResolvedVersion 2003

Olubunmi has attended:
Excel Intermediate course
Excel Advanced course
Word Intermediate course
Word Advanced course

Print preview

How do I remove page breaks?

RE: Print preview

Hi Olubunmi,
Thank you for your post, I was sure that I had answered this post before, but it seems not: however here goes,
viewing your worksheet in Page Break Preview will show the page breaks as blue lines (dotted or complete).
To remove a page break either in Page Break Preview or in Normal view select the column immediatly to the right of the page break and from the Insert menu choose the option Remove Page Break, regards Pete

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

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.