Difference between revisions of "Documentation/FAQ/Calc/Printing/How I do select a row (or rows) in my spreadsheet to repeat on every page when printed?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Printing
(New page: {{DISPLAYTITLE: How I do select a row (or rows) in my spreadsheet to repeat on every page when printed?}} <section begin=question/> '''How I do select a row (or rows) in my spreadsheet to...) |
m |
||
Line 6: | Line 6: | ||
<section begin=answer/> | <section begin=answer/> | ||
− | # Select | + | # Select {{menu|Format|Print Ranges|Edit}} from the main menu |
# Place the cursor in the input field on the '''Rows to repeat''' line | # Place the cursor in the input field on the '''Rows to repeat''' line | ||
#* Enter the row number manually (e.g. $4 for row 4, $4:$6 for rows 4 to 6), or | #* Enter the row number manually (e.g. $4 for row 4, $4:$6 for rows 4 to 6), or | ||
− | #* Click on the icon to the right of the input field, then select a cell on the desired row from the spreadsheet.<br>Multiple rows can be specified dragging your mouse across a range of cells. | + | #* Click on the icon to the right of the input field, then select a cell on the desired row from the spreadsheet.<br>Multiple rows can be specified by dragging your mouse across a range of cells. |
− | # Click | + | # Click {{button|OK}}. |
− | + | {{Note|* The row(s) specified here will be repeated on each print. | |
− | * The row(s) specified here will be repeated on each print. | + | |
* You will not see a visual change in the spreadsheet, only in the printed copies. | * You will not see a visual change in the spreadsheet, only in the printed copies. | ||
− | * Use | + | * Use {{menu|File|Page Preview}} to preview pages before printing. |
− | * You an only select multiple rows | + | * You an only select multiple rows if they are consecutive.}} |
Revision as of 12:34, 6 October 2021
How I do select a row (or rows) in my spreadsheet to repeat on every page when printed?
- Select Format → Print Ranges → Edit from the main menu
- Place the cursor in the input field on the Rows to repeat line
- Enter the row number manually (e.g. $4 for row 4, $4:$6 for rows 4 to 6), or
- Click on the icon to the right of the input field, then select a cell on the desired row from the spreadsheet.
Multiple rows can be specified by dragging your mouse across a range of cells.
- Click OK .