With the Idaho, Montana, and Oregon worksheets still grouped, create a formula as follows:
a. Enter a formula in cell B10 using the SUM function that totals the sales for Q1.
b. Copy the formula to the range C10:E10.
Ungroup the worksheets and then check to confirm that the formatting and formulas from Steps 6-8 are present in all three worksheets.
Make sure the worksheets for Idaho, Montana, and Oregon are grouped. You can do this by clicking on the tab for Idaho, then holding down the Ctrl key and clicking on the tabs for Montana and Oregon.
With the worksheets grouped, select cell B10 in one of the grouped sheets.
Enter =sum(b6:b9) in B10.
b.
With cell B10 (where you just entered the formula) still selected, move your cursor to the bottom-right corner of the cell until it turns into a small black cross.
Click and drag to the right to copy the formula into cells C10, D10, and E10. Excel will automatically adjust the formula for each column.
To ungroup the worksheets, right click on the bottom tab of any of the grouped worksheets and select 'Ungroup Sheets' from the context menu.
After ungrouping, you can click on each individual worksheet (Idaho, Montana, and Oregon) to confirm that the formatting and formulas from the previous steps are present in all three worksheets.
a.
b.
To ungroup the worksheets, right click on the bottom tab of any of the grouped worksheets and select 'Ungroup Sheets' from the context menu.
After ungrouping, you can click on each individual worksheet (Idaho, Montana, and Oregon) to confirm that the formatting and formulas from the previous steps are present in all three worksheets.
Video