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

print preview

ResolvedVersion 2007

Anna has attended:
Excel Advanced course

Print Preview

After I click Print Preview and then close it, Excel divides my screen into 3 pages. How can I remove those dividing lines?

RE: Print Preview

Hi Anna

Thank you for your question. One way would be to go to the Office Button > Excel options > Advanced
Then scroll down to Display options for this worksheet and remove the tick from Show page breaks.

You should also find if you close (saving any changes if necessary) and reopen the file the page break marks will vanish.

I hope this helps do let us know if you have any further questions.

Kind regards,
Andrew

Thu 24 Feb 2011: Automatically marked as resolved.

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

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.