Ask Your Question

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: Thanks.

edit retag flag offensive close merge delete


I just discovered that there were TONS of spaces in a cell in a spreadsheet that was created in Excel (almost as if the creator had leaned something against the keyboard and pressed and held the space bar). While Excel appears to ignore them as white space, Calc appears to consider these spaces as printable characters, resulting in the entire page showing up as a tiny little square at the top left. Once those errant spaces were removed, the page printed normally. Hopefully, this will help someone in the future.

ckelley gravatar imageckelley ( 2020-09-30 18:15:08 +0200 )edit

3 Answers

Sort by » oldest newest most voted

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

LHGordon gravatar image

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

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


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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 7,228 times

Last updated: Mar 23 '19