Freezing rows and printing a wide sheet on one page

In a long list, you want to keep the headings in view as you scroll down. When you print, all columns should fit on one sheet of paper and the headings should appear on every page. In Excel, freezing is called Freeze Panes.

In LibreOffice Calc: freezing on screen

• Only the top row: View > Freeze Cells > Freeze First Row. For the first column, choose Freeze First Column.
• Several rows and columns: click the cell just below and to the right of the part that should stay in place, for example B3 for rows 1 and 2 and column A, and choose View > Freeze Rows and Columns.
• To unfreeze: choose the same menu item again.

In LibreOffice Calc: printing

All columns on one page wide

1. Choose Format > Page Style... and go to the Sheet tab.
2. Under Scaling mode, choose Shrink print range(s) to width/height.
3. Tick Width in pages and set it to 1. Untick Height in pages, so a long list can continue over several pages. Click OK.

A wide table fits better in landscape: in the same window, on the Page tab, choose Landscape under Orientation.

The header row on every page

1. Choose Format > Print Ranges > Edit.... The Edit Print Ranges window opens.
2. Click in the box next to Rows to Repeat and select the row with your headings in the sheet, for example row 1. It will show $1. Click OK.

Use File > Print Preview to check that everything looks right before you print.

In Euro-Office

• Freezing: View tab, Freeze panes, for example Freeze top row. See Freezing rows and columns.
• Printing on one page wide: Layout tab, Scale to fit, Width set to 1 page. To repeat the header row, use Print titles. See Printing a wide worksheet on one A4 page, with the header row on every page.