1. Select a cell(s) that contains the data to be copied.
2. Right-click the sheet tab, and from the shortcut menu, select Select All Sheets, or hold down the
3. Select Home -> Fill (in Editing Group) -> Across Worksheets.
4. In the Fill Across Worksheets dialog box, check one of the three option buttons and click OK.
5. To remove sheet groupings, hold the
Or
Right-click one of the sheets tabs and select Ungroup Sheets from the shortcut menu.