You need to print a worksheet that shows sales information, but you would like to print it on four pages. Additionally, a page break must appear between the years and the regions. All pages also need title information for each row and column.
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/rEFINING%20THE%20PAGE%20LAYOUT.xlsx
2. Insert a manual page break by first selecting cell H1 and then clicking Page Layout → Breaks → Insert Page Break:
3. Insert another manual page break by selecting cell H27 and then clicking Page Layout → Breaks → Insert Page Break:
4. Next, use your cursor to select the D6:K50 range:
5. Click Page Layout → Print Area → Set Print Area:
6. Next, with the previously selected cell range still selected, click Page Layout → Print Titles:
7. The Page Setup dialog box will now be open to the Sheet tab. Click the cell selector button on the far right of the Rows to repeat at top text box:
8. Your worksheet will now be shown. Click and drag to select rows 1 through 5:
9. In the cell selector dialog box, click the cell selector button to return to the Page Setup dialog box, or press Enter:
10. Back at the Page Setup dialog box, click inside the Columns to repeat at left text box and type “$A:$C”:
11. Click OK to apply the new settings:
12. Click File → Print:
13. Examine the preview portion of this screen. You will see that the current worksheet has been divided into four pages. Each page has both column and row titles:
14. Save your workbook as Activity 4-2 Complete. Close Microsoft 365 Excel to complete this activity.
15. Now, you can check out an example of a completed document in the link below:
No comments:
Post a Comment