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