Decreasing font size below 8 or suggestions reducing number of spreadsheet pages to print

B

bob green

I have a spreadsheet that prints to 18 pages. There are only 11 rows
on a second page when scrolling down and 5 columns on the 7th page
across.

If I could reduce the font to 6 or 7, I believe I could fit the text
on just 6 pages. All variable labels are lower case and I have used
autoformat to reduce colum width. Any other suggestions are
appreciated.

regards

Bob Green
 
F

Frank Kabel

Hi
just highligt your cells and MANUUALLY enter a '6' in the combo box for
the font size (though it shows only 8 as smallest number you can m,an
ually enter other sizes)
 
G

Guest

I’m not quite sure, but if you go to the Page Setup you will find an option to fit your page to the width of 1 page and to the height of 1 to 999 pages. So, you can set the height to 6 pages and the Excel will fit it automatically

----- bob green wrote: ----

I have a spreadsheet that prints to 18 pages. There are only 11 row
on a second page when scrolling down and 5 columns on the 7th pag
across

If I could reduce the font to 6 or 7, I believe I could fit the tex
on just 6 pages. All variable labels are lower case and I have use
autoformat to reduce colum width. Any other suggestions ar
appreciated

regard

Bob Gree
 
B

bob green

I have a spreadsheet that prints to 18 pages. There are only 11 rows
on a second page when scrolling down and 5 columns on the 7th page
across.

If I could reduce the font to 6 or 7, I believe I could fit the text
on just 6 pages. All variable labels are lower case and I have used
autoformat to reduce colum width. Any other suggestions are
appreciated.

regards

Bob Green
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top