Time-Saving Tip – Enter Data Into Multiple Excel 2007 Worksheets At Once

Here’s a scenario for you. Imagine having to type in 500 column entries into an Excel worksheet and then having to enter the same data into two other worksheets. Sounds like a lot of work doesn’t it? The fact is, there are times when you need to enter the same data into multiple worksheets within a single spreadsheet. For example, if you need the same list of names to appear on more than one worksheet. One method you can use is to enter all the data into one worksheet then copy it over to the other ones. Or, you can use the time saving tip described below.

Instead of re-typing or copying the same data between worksheets, you can use the Group feature. Once you group two or more worksheets, any data you type into one worksheet appears in the other worksheets within the group. So let’s take a look at how you can do this.

With your workbook open, hold down the CTRL key while clicking the worksheets you want to group. Notice that the tabs of any grouped worksheets turn white.

Excel Data

Click on one of the grouped worksheets and enter in your data. As you type in one worksheet, Excel automatically enters the same data into the other grouped worksheets.

Once you are finished you can ungroup the worksheets by right clicking any sheet name and selecting the ungroup option.

Excel Data

Article Written by

  • Guest

    It will work in every Excel version, not just Excel 2007

  • Hal Wexler

    In my version of Excel 2007 it requires the “Select All Sheets” command prior to the “Ungroup” command?