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 key and click the last sheet tab.
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 key and then click the first sheet tab.
Or
Right-click one of the sheets tabs and select Ungroup Sheets from the
shortcut menu.


"VBL" wrote:

Excel previously had an option to "fill across worksheets" if you entered
something in one before selecting all worksheets. It was under the Edit
dropdown menu. I cannot find that option on the new Excel. How can I make
this happen?