Microsoft Excel - How to Enter or edit the same data on multiple worksheets?

When you select a group of sheets and then change data on one of them, the same changes are applied to all the selected sheets. Data may be replaced in the process.

1. Select the worksheets where you want to enter data.
2. Select the cell or cell range where you want to enter data.
3. Type or edit the data in the first selected cell.
4. Press ENTER or TAB.

Note  To cancel a selection of multiple sheets, click any unselected sheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.