Ask Your Question
0

I can't print a spreadsheet to fit the page

asked 2016-03-13 09:27:01 +0200

Sharon gravatar image

I have spent 6 hours now trying to find help on how to fit a spreadsheet onto a printed sheet. I have set my page margins at 0.5" and yet, the spreadsheet prints out utilizing a tiny, tiny portion of the page, and I have searched and searched trying to figure this out. I've tried the print preview command - sheet - scale and tried all three options, but none work. The best that I can achieve, to utilize the full size of the 8.5" x 11" sheet of paper, is to use "Reduce/enlarge printout" and set it to 87% but everything is too small to read at 87%. I want 100% and I want to fill the piece of paper that I am printing on, which is 8.5" x 11". I have the page set on Landscape. If anyone could help me, I would be grateful. Also, I am using Version: 5.1.0.3. Thanks.

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
0

answered 2016-03-13 16:47:13 +0200

brucehohl gravatar image

I think you may have some spaces or other non-visible characters in cells outside the range you want printed. Press Ctrl+End to see the recognized end of your sheet. Delete unwanted cells, rows, columns.

Or, select the range of cells that you want printed. Then on the Print window choose "Selected Cells".

edit flag offensive delete link more

Comments

Thank you! I will try again :) Now, I have to figure out how to give you a vote, or whatever it's called here, for being kind and answering my question. You are very much appreciated!

Sharon gravatar imageSharon ( 2016-03-23 05:29:01 +0200 )edit

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2018-05-15 00:17:23 +0200 )edit
0

answered 2018-05-14 17:43:12 +0200

rir gravatar image

For spreadsheets sent in email, you may want to look at the menu item View/Page Break. This shows lines at the boundary of pages. These lines can be grabbed and moved. I have only used this to fix page width on versions 5.2.7 and 4.3.3.

edit flag offensive delete link more
0

answered 2019-03-23 22:14:18 +0200

I have a similar problem but if your only printing 1 page at a time and set a print range for the page you are trying to print, then you can use the zoom command to change the size to fit the margins. However you cannot change the height of the header and footer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-03-13 09:27:01 +0200

Seen: 4,313 times

Last updated: Mar 23