Ask Your Question
0

How to fit column contents to page size?

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

etsnyman gravatar image

Hi!

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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

JohnSUN gravatar image

Perhaps you are looking for these options image description

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

edit flag offensive delete link more

Comments

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 +0200 )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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 621 times

Last updated: Jul 27 '18