When we work in Excel, very often we need to enter the same data in multiple sheets. It’s time consuming and monotonous to write the same thing on every sheet. But there’s a way to do that quickly in Excel. We will group the sheets together to enter same data in multiple sheets.
You can download the practice worksheet from below
Steps to Enter Same Data in Multiple Sheets in Excel
With a very quick few steps, we can reduce a lot of hard work. In this article, we will show you the steps to enter the same data in multiple sheets in Excel.
Step 1: Creating Multiple Sheets
At first, we need to create the required number of sheets by just clicking on the Plus option beside the name of the current worksheet. We rewrite the name of the sheets. In our case, we created three sheets with the name Player Set 1, Player Set 2, and Player Set 3.
Now we fill up the data of multiple sheets.
Payer Set 1
We keep the cells empty whose value we will write altogether.
Player Set 2
Player Set 3
Read More: Transfer Data from One Excel Worksheet to Another Automatically
Step 2: Grouping Multiple Sheets
Now we group worksheets by selecting the active sheet, pressing and holding the CTRL key, and selecting the rest sheets through a mouse click. In our case, we select Player Set 2 and Player Set 3.
- How to Pull Values From Another Worksheet in Excel
- How to Pull Data From Another Sheet Based on Criteria in Excel
- Extract Text After a Character in Excel (6 Ways)
- How to Extract Month from Date in Excel (5 Quick Ways)
- VBA Code to Convert Text File to Excel (7 Methods)
Step 3: Input Same Data
Now we enter the desired data in the active sheet which we want to copy on all selected sheets.
Player Set 1
We’ve entered the country for those players in sheet 1. Let’s see the next sheet.
Player Set 2
Hurrah! We did it. The data are copied to every sheet.
We checked if the data were copied in sheet 3.
Player Set 3
Hurrah! The data Portugal and Argentina were copied to Player Set 2 and Player Set 3.
Read More: Importing Data into Excel (3 Suitable Ways)
Step 4: Ungroup Multiple Sheets
Now we will ungroup our sheets for regular use. We will select the active sheet then press and hold CTRL and select the rest cells and the ungrouping is done.
Now we can input regular data and can use it as usual.
Advantages of Entering Same Data in Multiple Sheets
Frequently we input the same data on several sheets which is time consuming and monotonous work. We can easily reduce the hard work only by grouping the sheets. It’s a very quick and easy process.
In this article, we showed the way to enter the same data in multiple sheets in Excel. Grouping sheets is very fast and smooth to enter the same data quickly in multiple sheets. Hope this article will help you. If you face any problem following the steps or if you have any suggestions, please let us know in the comment section below.
- How to Import Data from Word to Excel (3 Easy Methods)
- How to Extract Data from Website to Excel Automatically
- Extract Filtered Data in Excel to Another Sheet (4 Methods)
- How to Return Multiple Values Based on Single Criteria in Excel
- How to Transfer Data from One Sheet to another in Excel Using Macros
- Excel Macro: Extract Data from Multiple Excel Files (4 Methods)