Once you have selected all of the worksheets you need to See here to find out howYou can type or paste data into a cell, and that same data is inserted into each cell on the selected worksheets.
Let’s as always run through an example
Open up a new workbook with 3x worksheets
1. Select all 3 worksheets
2. Type Cost of Widgets in Cell A1 on Sheet 1. Cost of Widgets will then appear on all three sheets in cell A1
You can also use the Auofill option on Excel to copy a series or existing data onto multiple worksheets
1. select the worksheet that contains your data or the beginning of the series of data you want to copy.
2. select the additional worksheets to copy data to
3. Select the range of cells from which you want to copy your data or the start of the series of data
4. Edit | Fill | Across worksheets.
The fill across worksheets box will then be displayed.
You then have the choice to copy All or Contents or Formulas
Click ok.
Let’s give this a go. On your workbook on sheet 1, under Cost of widgets type
Widget A in cell A2
widget B in cell A3
Widget C in cell A4
Select the cells you have just typed
Select the addional sheets 2 and 3
1. Edit
2. Fill
3. Across worksheets
4. Copy All
You should now have the same cells populated on all your worksheets!- great work go grab yourself a coffee!