Back to lesson
1. Imagine that you have a spreadsheet to print, and you want all columns to fit on one page while allowing as many pages to be printed as necessary for all rows to be displayed. Which method is the best?
In Print Preview, set the scaling to “Fit Sheet on One Page”.
On the Page Layout tab, set Width to 1 page.
Manually scale the job until it fits the required page width.
2. How do you get Excel to print the date and time of the print job in the header for each page?
Go to Page Layout, and then Print Titles and Custom Header, and type “Printed “ and click the date and time icons.
Go to Print Preview and check the “Time stamp in header” option.
Use the formula =NOW() in row 1, and then repeat row 1 at the top of each page to be printed.
3. Suppose you want to repeat the top 5 rows of your spreadsheet on every page printed. Where do you go to configure this?
In the Print Layout tab, click the Print Titles button in Page Setup.
In the Print Layout tab, click the Print Areas button in Page Setup.
Via Print Preview.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement