adding width and columns to spreadsheet

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

Hello,

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 (:heavy_check_mark:) next to the answer.