openoffice calc print column headers each page

Sorting and filtering in Calc can be accessed using the Sort and Filter section in Standard Toolbar. This is done using the Sorting and Filtering tools.

Furthermore we can use Calc as a simple database tool and ask simple questions in order to extract useful information from our data. PS If this answers your question, please mark it as SolvedWhen working with data in a spreadsheet we often need to arrange and organize the data for better viewing and finding. Let me know how you get on and do get back to me if you need more help. Just one tip - always print on plain paper first to check that the printing is correctly lined up. For the example from the link above, which only has 5 tabs, you would need them repeated 10 times and 2 tabs will be unused.

Does your format have 2 columns of 26 rows of tabs? Then you will have to repeat the tabs as many time as you need to fill the page. You will probably only need one column of data with a heading in row 1 (say, 'Tab Text') with each cell below it containing the text for one of the tabs. To follow the FAQ I quoted, you will first need to list the tab contents in a Calc spreadsheet. If not, you will have to put the data from the printing tips (Para 4 in the example in the link above) into the label dimensions on the Format tab and Save them as a user defined format.

In which case you may find them listed under Format on the Labels dialogue as a Type with Brand changed to Avery Letter Size. Com/avery/ en_us/Products/ Dividers/ Insertable- Dividers/ WorkSaver- 5-.5in- x-8-.5in- Insertable- Tab-Dividers- with-Buff- Paper_11102.

Openoffice calc print column headers each page