printing large workbooks

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Printing large workbooks

Printing large workbooks

resolvedResolved · Low Priority · Version 2003

Carole has attended:
Excel Intermediate course

Printing large workbooks

How do I print a large workbook so that the data on each printed page is linked and doesnt split over 2 pages?

RE: Printing large workbooks

Hello Carole
Thank you for your question

Open the document and go to File, Page set up. On the Page tab is a scaling section where there is an option to Fit the entire sheet to 1 page in height and width. Before you print anything, go to file, Print Preview to see how it will look. Beware that if your spreadsheet contains masses of data then the size of the font will be reduced to fit it on the page.


If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Tue 31 Mar 2009: Automatically marked as resolved.


 

Excel tip:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips


Server loaded in 0.07 secs.