print preview
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Print Preview

resolvedResolved · Low Priority · Version 2007

replyReply Wed 16 Feb 2011, 11:12Delegate Anna said...

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?

For upcoming training course dates see: Pricing & availability

replyReply Thu 17 Feb 2011, 16:51Trainer Andrew said...

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.

 

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

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard