Saturday, December 25, 2021

TEACHING EXCEL FOR DATA ANALYSIS: HANDS ON PRACTICE 10 Refining the page layout and applying print options

 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:

Excel workbook open, Cell H1 selected, Page Layout tab selected, Breaks clicked, Insert Page Break option selected.

3. Insert another manual page break by selecting cell H27 and then clicking Page Layout → Breaks → Insert Page Break:

Excel workbook open, Cell H27 selected, Page Layout tab selected, Breaks clicked, Insert Page Break option chosen

4. Next, use your cursor to select the D6:K50 range:

Excel workbook open, the Cells D6 to K50 selected

5. Click Page Layout → Print Area → Set Print Area:

Excel workbook open, the Cells are selected, Page Layout tab selected, Print Area selected, Set Print area option chosen

6. Next, with the previously selected cell range still selected, click Page Layout → Print Titles:

Page Layout selected, Print Titles option selected

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:

Page Setup dialog window open, Cell selector button clicked 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:

Excel workbook open, the rows 1 through 5 was selected

9. In the cell selector dialog box, click the cell selector button to return to the Page Setup dialog box, or press Enter:

Page Setup dialog box open, Cell selector button clicked

10. Back at the Page Setup dialog box, click inside the Columns to repeat at left text box and type “$A:$C”:

Page Setup dialog box open, Columns to repeat at left box text selected, typed "$A:$C"

11. Click OK to apply the new settings:

Page Setup dialog open, "OK" button clicked

12. Click File → Print:

File option selected, Print option selected

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:

Print dialog window open, workbook appears in the preview area with the changes applied

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:

https://github.com/alcadelina/Excel-

No comments:

Post a Comment