Monday, December 27, 2021

TEACHING EXCEL FOR DATA ANALYSIS HANDS ON 23 Managing the view of worksheets and workbooks

 

Managing the view of worksheets and workbooks

Your current project requires that you work with multiple workbooks at the same time. To make things easier, you will use some of the features that you learned about during this topic.

1. Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

Note: Click on the links below to open the set of files that you can use to complete this exercise.

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

2. Make sure Managing the view of worksheets and workbooks A is the active workbook, and Product Usage is the active worksheet. Click cell B2 then click View → Freeze Panes → Freeze Panes:

Excel workbook, Freeze Panes, small pane open, Freeze Panes option chosen

3. Now use the Scroll bar down and right buttons to scroll your data. Note that the column and row headers are frozen:

Excel workbook open, the Scroll bar down and right buttons in the right side of the document are highlight

4. Make the Managing the view of worksheets and workbooks B workbook active by clicking View → Switch Windows → Managing the view of worksheets and workbooks B:

Excel workbook open, View tab selected, Switch Windows option selected, Activity 5-3B option chosen

5. Click cell D27 then click View → Split:

Excel workbook open, Cell D27 selected, View option selected, Split option chosen

6. Click and drag the Scroll bars to scroll the data in each quadrant:

Excel workbook open, the Scroll bars was clicked and dragged, the data was scrolled in each quadrant

7. Now click and drag the center of the dividers one column to the left:

Excel workbook open, the center of the dividers was clicked and dragged to one column to the left

8. You can now click View → Split, to remove the dividers:

Excel workbook open, View tab selected, Split option was selected

9. Return to the Managing the view of worksheets and workbooks A workbook by clicking View → Switch Windows → Managing the view of worksheets and workbooks A:

Excel workbook open, View tab selected, Switch Windows option chosen, Activity 5-3A selected

10. Now add a new window by clicking View → New Window:

Excel workbook open, View tab selected, New Window option selected

11. In the new window labelled Managing the view of worksheets and workbooks A – 2, click on cell F2 and type “Total” and then press Enter:

Excel workbook open in Activity 5-3A-2, Cell F2 selected and typed "Total" and Enter key clicked

12. Now click View → Switch Windows Managing the view of worksheets and workbooks A – 1:

Excel workbook open, View tab selected, Switch Windows open, Activity 5-3A-1 selected

13. Note that the change you made in the one window is also reflected in the other window:

Excel workbook open, the changes was applied in the document

14. Save your workbooks as Completed_Managing the view of worksheets and workbooks A and Completed_Managing the view of worksheets and workbooks B. 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-

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)