Miley wants to perform the same calculations on four worksheets with identical structures.To group the worksheets and perform the task faster, she can make the change on one worksheet, right-click the worksheet tab, and then click Duplicate Changes on the shortcut menu.

Question

Quizplus · Accepted Answer

To group worksheets in Excel, you can select the first worksheet, hold down the Shift or Ctrl key, and then select the other worksheets you want to group. There is no "Duplicate Changes" option in the shortcut menu; changes made in one sheet of a grouped selection automatically apply to all sheets in the group.

Miley Wants to Perform the Same Calculations on Four Worksheets