How to insert data in multiple excel sheets simultaneously?


Anyone can insert data in multiple Excel sheets by grouping the multiple sheets. To group multiple sheets, hold the Ctrl key & select your desired sheets.

For Example: I have created a new blank workbook that has three sheets: Sheet1, Sheet2 & Sheet3.

Fig 1: Blank Workbook



Fig 2: Group sheets by holding CTRL key + Select 


Fig 3: Now insert the data in one sheet


Fig 4: The same data were automatically copied in all the select sheets
 
Benefits:
  • Saves time & effort.
  • Useful for large Excel workbook.
  • Easy to perform.


 

 

Comments

  1. Mansi have there any scenario where we need same data on multiple sheets???

    ReplyDelete
  2. Yes in some cases it is necessary but depends upon the users requirement.

    I have used it to maintain multiple sheets of same data.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to resolve Excel error “MS Office Excel is waiting for another application to complete an OLE action"

Why does Excel File size increase and how to reduce it?

Are you Unable to save your Excel file? Here is the solution