A large workbook that you have been working with needs to be printed out. Before you do so, you need to ensure that everything will fit on the printed pages.
1. Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.
https://github.com/alcadelina/Excel-
https://github.com/alcadelina/Excel-/blob/main/Previewing-a-Workbook-Before-Printing.xlsx
2. Click File → Print:
3. With the Print category now open in the Backstage view, you will see a preview of the current worksheet:
4. Right now, only the currently displayed worksheet will be printed. Within the Settings section, click Print Active Sheets → Print Entire Workbook:
5. In the bottom left-hand corner of the preview area, click the Next Page button:
6. The second worksheet in the workbook is now displayed:
7. Click the Next Page button until you reach page 4. Note that the third sheet does not fit within the defined page boundaries and has flowed to a fourth page:
8. Within the Settings section, click Portrait Orientation → Landscape Orientation:
9. The page orientation is now landscape and the print preview is now displaying page 3 of 3:
10. Apply the same settings to pages 1 and 2, by first clicking the Previous page button, and again clicking Portrait Orientation → Landscape Orientation:
11. Save your workbook as Activity 4-1 Complete. Close Microsoft 365 Excel to complete this activity.
12. Now, you can check out an example of a completed document in the link below:
https://github.com/alcadelina/Excel-
https://github.com/alcadelina/Excel-/blob/main/Completed_Previewing%20a%20Workbook%20Before%20Printing.xlsx
No comments:
Post a Comment