Ask Your Question

Rows get cut off in spreadsheet when printing

asked 2020-01-14 22:27:23 +0100

SirChris93 gravatar image

I work at a computer repair shop and we made an inventory sheet for parts. However whenever we print it the last two rows get cut off on the front and printed on the back, I can't seem to figure out how to fix this issue. I would like to keep it in portrait and the font the way it is if possible. Any help would be appreciated.

How I want it to look

What I do to bypass it I really don't like it this way because it's confusing and doesn't look nice

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-01-14 23:19:04 +0100

Opaque gravatar image

updated 2020-01-14 23:49:36 +0100


in fact you don't take control what and how your table will be printed. In general, to get full control you need to configure two things:

1) Print Ranges

Use Format -> Print Ranges...-> Edit to define $A$1:$J$22 as range of cells to be printed:

image description

2) Print Scaling

Use Format -> Page -> Tab: Sheet -> Category: Sheet -> Dropdown: Scaling mode. In case you want everything of the print range to appear on a single page select Fit print ranges(s) on number of pages and select Number of pages: 1

image description

Hope that helps.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more


Thank you so much :) it worked!!!

SirChris93 gravatar imageSirChris93 ( 2020-01-15 15:55:35 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-14 22:27:23 +0100

Seen: 17 times

Last updated: 2 days ago