Ask Your Question

adding width and columns to spreadsheet

asked 2020-02-10 22:04:50 +0100

I created a spreadsheet but it has a dotted line limiting how far to the right I can have columns. How do I move that right edge wider so I can print more columns on a single page

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-02-10 22:55:13 +0100

Opaque gravatar image

updated 2020-02-11 10:32:07 +0100


this line is not a limiting line, but an indicator line, showing you, where the page breaks will occur as per your current settings. You cannot move this line, but you need to adapt your settings and after doing so, this line will show you the page breaks as per your new setting (How many columns fit into a single page obviously must be a function of font sizes, column width, scaling and therefore you need to adapt such settings, if you want to achieve more columns to fit into one page. A simple drag the line to right-function neither would change any of the parameters nor would it widen the paper available in your printer).

To change the settings adapt:

  • Go to Format -> Page -> Tab: Sheet
  • Check and adapt section Scale Drop Down Scaling mode and select how you want the tables to be printed -- and/or modify the Scaling factor to some lower level.

Read LibreOffice Help - Sheet about the various printout options available.

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

Question Tools

1 follower


Asked: 2020-02-10 22:04:50 +0100

Seen: 14 times

Last updated: Feb 11