Fit to page A4 with calc problem

Hi, I’m new to LibreOffice (french) and I can’t find a way to fit to a A4 page my table when I want to print it.

I mean, when I create rows and collums, I don’t see how much space it’s gonna take on a page of paper…

Any idea?

Two places to set:

Menu/Format/Print Ranges

Here you can define the ranges to print in the sheet, and rows and columns to repeat as headings.

Menu/Format/Page - Sheet - Scaling mode.

Here you have three options.

e.g. if you do not define a range the Scaling mode, and set Print ranges to number pages = 1, the an Auto adjust is made even if you add more rows or columns.

Play a bit with the options and I think you can find how to do it as you need.

  1. Click Page Preview icon (Ctrl+Shift+O)
  2. Then Click Format Page
  3. And select Scaling mode to “Fit print range(s) to width/height
  4. Click OK
  5. Then Click Print File Directly icon (printer icon) to print

Format > Page > Page > Paper Format > Format (Select ‘A4’) > OK. This should get the page outlines / limits to be visible on your Worksheet. You can also set your margins to suit your requirements.

Follow the advice of mariosv,. which is a good one, but if you can’t get the right print-out let us know what do you want to print out:
calc, writer, or… landscape or portrait.