Instructor Explanation: If you were to flip through the worksheets, you will see that the monthly worksheets have the company name in cell A1. If the name on each monthly worksheet needs to be changed, it is not necessary to edit each one separately. Here’s How: Click to select the January worksheet tab Press and hold the Shift Key Click to select the June worksheet tab (you have selected all worksheets from January to June Click in cell A1 to select the cell Type: Wellness Spa & Salon Press Enter Check each worksheet to observe the name change on all selected worksheets With the worksheets still grouped, add the Sheet Name to the center header section. Switch back to Normal View if necessary. Instructor Explanation: You can add document information by using headers and footers that appear in the top or bottom margin area of the page. Here’s How: If necessary, select worksheets January to June On the Insert Ribbon, Text Group, click the Header & Footer Button Observe that you have changed from Normal View to Page Layout View Click in the center of the header section On the Design Ribbon, Header & Footer Elements Group, click Sheet Name Observe the code that will print the name on the worksheet tab in the header Double-click in the normal part of the worksheet to get out of the header On the View Ribbon, Workbook Views Group, click the Normal Button With the worksheets still grouped, format cell A1 using the Green, Accent 1, Lighter 60% (5th column, 3rd row of the Theme Colors palette) fill color. Here’s How: If necessary, select worksheets January to June Click to select cell A1 On the Home Ribbon, Font Group, click the Fill Color drop-down arrow Select Green, Accent 1, Lighter 60% With the worksheets still grouped, set a 1” custom margin on the Top of the worksheets. Ungroup the worksheets. Here’s How: If necessary, select worksheets January to June On the Page Layout Ribbon, Page Setup Group, click the Margins Button Click Custom Margins In the Page Setup dialog box, change the top margin to 1” Click OK
Instructor Explanation: If you were to flip through the worksheets, you will see that the monthly worksheets have the company name in cell A1. If the name on each monthly worksheet needs to be changed, it is not necessary to edit each one separately. Here’s How: Click to select the January worksheet tab Press and hold the Shift Key Click to select the June worksheet tab (you have selected all worksheets from January to June Click in cell A1 to select the cell Type: Wellness Spa & Salon Press Enter Check each worksheet to observe the name change on all selected worksheets With the worksheets still grouped, add the Sheet Name to the center header section. Switch back to Normal View if necessary. Instructor Explanation: You can add document information by using headers and footers that appear in the top or bottom margin area of the page. Here’s How: If necessary, select worksheets January to June On the Insert Ribbon, Text Group, click the Header & Footer Button Observe that you have changed from Normal View to Page Layout View Click in the center of the header section On the Design Ribbon, Header & Footer Elements Group, click Sheet Name Observe the code that will print the name on the worksheet tab in the header Double-click in the normal part of the worksheet to get out of the header On the View Ribbon, Workbook Views Group, click the Normal Button With the worksheets still grouped, format cell A1 using the Green, Accent 1, Lighter 60% (5th column, 3rd row of the Theme Colors palette) fill color. Here’s How: If necessary, select worksheets January to June Click to select cell A1 On the Home Ribbon, Font Group, click the Fill Color drop-down arrow Select Green, Accent 1, Lighter 60% With the worksheets still grouped, set a 1” custom margin on the Top of the worksheets. Ungroup the worksheets. Here’s How: If necessary, select worksheets January to June On the Page Layout Ribbon, Page Setup Group, click the Margins Button Click Custom Margins In the Page Setup dialog box, change the top margin to 1” Click OK
excel-module-6-instructions_il_ex16_6a.docx