98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Printing spreadsheets
Printing spreadsheets
Resolved · Low Priority · Version 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Recovering Unsaved Work in Excel 2010Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back. |