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

printing spreadsheets

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

Printing spreadsheets

ResolvedVersion 2003

Teena has attended:
Excel Intermediate course

Printing spreadsheets

Can I have some tips on printing large spreadsheets that keep the font at a readable size.

RE: printing spreadsheets

Hi Teena,

Thank you for your post, and welcome to the forum.

The only way you are going to achieve this is to break your worksheet into manageable chunks, if you use the Page Break Preview operation, View>Page Break Preview, you can manually move the blue dotted lines (page breaks) to positions where you feel a natural page break will occur, this will enable you to shrink the font automatically to fit the size of page, without making it too small that it cannot be read comfortably. Dont forget that you can repeat column and row headers by using the File>Page Setup and choosing the last tab 'Sheet' you will find the options under Print Titles, simply click in the text box then click or drag in the worksheet to indicate which columns/rows are to be repeated.

I hope that has helped a bit, if so please click the resolved link, regards Pete

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

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.09 secs.