Entering Data Onto Multiple Excel Worksheets


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!

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts