Ask Your Question

How to fit column contents to page size? [closed]

asked 2018-07-27 17:01:27 +0100

etsnyman gravatar image

updated 2020-07-21 23:33:52 +0100

Alex Kemp gravatar image


I'm not quite sure how to describe what I'm looking for, but I'll give it a go!

I have a spreadsheet that I want to fit onto one page, but without scaling the size! I only want the columns to be spread evenly across the page.

If, for instance, I want one column to be bigger, then I want the column sizes of the rest of the columns to become smaller so that, when printed, the spreadsheet fits onto one page (width-wise).

I did this in Excel no problem a while ago, but I can't remember what I did.

How can I, in Calc, get the Columns to auto-size to fit one page, without scaling the contents (e.g. not scaling the text, image, and chart size etc.)?

Thank you for your kind help. I look forward to your friendly responses!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-21 23:34:17.908949

1 Answer

Sort by » oldest newest most voted

answered 2018-07-27 19:25:11 +0100

JohnSUN gravatar image

Perhaps you are looking for these options image description

(It's in menu Format-Page...)

edit flag offensive delete link more


IIUC this is still a scaling method that would scale "the text, image, and chart size etc." - that OP wanted to avoid. I am afraid we'd still need a description of how to do that in Excel to know if there is an alternative in Calc...

Mike Kaganski gravatar imageMike Kaganski ( 2018-07-28 00:27:48 +0100 )edit

Thanks for the help, JohnSUN and Mike Kaganski.

Mike is correct, that's not what I'm looking for.

I will try to find out how it's done in Excel and get back to you!

etsnyman gravatar imageetsnyman ( 2018-08-10 12:10:15 +0100 )edit

Question Tools

1 follower


Asked: 2018-07-27 17:01:27 +0100

Seen: 1,443 times

Last updated: Jul 27 '18