Tips for the print setting
If you need a one-sided printable timesheet per employee, we recommend the following print setting:
Landscape format, Adjust: 1 page
In addition, under Header/Footer, select the sheet name as the heading so that the reference to the employees is displayed on the individual pages.
The settings in this dialogue box only affect the current spreadsheet.
If you want to transfer print settings to another worksheet, proceed as follows:
- Activate the spreadsheet with the page layout settings to be transferred.
- Press the CTRL key and keep it pressed.
- Click one after the other in the table tab on the tables to which you want to transfer the layout.
- Release the CTRL key when you have selected all the desired tables in the table tab.
- Call up the SET UP PAGE dialogue box.
- Do not make any changes, but confirm the dialogue window with the OK button.
Excel then applies the settings of the current table to all marked sheets.