Making a spreadsheet fit the page

[Guest]

I have a spreadsheet printed on 11 x 17 inch paper with cells I would like to make as easy to read as possible. I cannot make the cells any wider (because I have so many columns already), but I was thinking the spreadsheet would be easier to read if I made the cells taller. Is there an easy way to have Excel automatically change the cell height so that the cells are as large as possible

I am familiar with the scaling function which appears in the Page Setup dialog box. However, that works by manipulating BOTH the length and the height of all cells in a worksheet. Can Excel be instructed to manipulate ONLY ONE OR THE OTHER at a time, so that I can make cells as easy to read as possible

Thanks

 

[Andy B]

MBP

The only way I can suggest is to copy your sheet as a picture, massage the
picture as necessary and print that.
If you select the cells you want, hold shift and click Edit and then Copy
Picture. On a new sheet you can then paste the picture and adjust as
necessary.

Andy.

I have a spreadsheet printed on 11 x 17 inch paper with cells I would like

to make as easy to read as possible. I cannot make the cells any wider
(because I have so many columns already), but I was thinking the spreadsheet
would be easier to read if I made the cells taller. Is there an easy way to
have Excel automatically change the cell height so that the cells are as
large as possible?

I am familiar with the scaling function which appears in the Page Setup

dialog box. However, that works by manipulating BOTH the length and the
height of all cells in a worksheet. Can Excel be instructed to manipulate
ONLY ONE OR THE OTHER at a time, so that I can make cells as easy to read as
possible?

 

[Guest]

Click on the corner of the spreadsheet between "1" and "A"
to select the entire spread sheet.
Click on "Format"; "Row"; "Height" and change the height
to desirable number.