

Many people choose the least complicated, and do nothing. Assuming that you have no outsized cells, with the same paper, you'll have 50-55 rows. For instance, if you are printing to US Letter size page with a portrait orientation and a one inch margin on every side, you'll have 6.5 inches for column widths.


In each of these cases, you may want to keep track of the total column width and the number of rows likely to be printed on each page. When you print from Calc, you have several options for selecting the contents: doing nothing, printing a selection, setting up a print range, or adding manual row and column breaks. None of these tools is useful on every occasion, and you may have to mix and match them to get the results you want, but, the more you know about them, the less of a nightmare printing a spreadsheet becomes. How you setup pages for printing and the printer or export options are also part of the arsenal. However, although page styles are one of the most useful tools for the task, they are far from the only ones.
Print selection libreoffice how to#
In part 1 of this entry, I discussed how to use Calc's page styles to control how spreadsheets print.
