Enter Data Into Several Worksheets At The Same Time….Manually


Excel has a built in mechanism to allow data to be entered into several worksheets at the one time, this feature is called Group.  This works by grouping the worksheets together  to they are all linked within the workbook.

To begin using the Group feature in Excel, select the sheet into which you are going to be entering the date and select the Ctrl key (shift key on the Mac) whilst clicking the Name tabs of the worksheets where you want the data to go.  When you begin to enter data into your worksheet, it will also be entered into the in the other grouped worksheets that you chose previously.

To Ungroup your worksheets, select one of the worksheets in your group, right click any name tab and select Ungroup Sheets.

One point to note on this, the grouping of the sheets is easy to do, and once your worksheets are grouped it is actually easy to forget they are grouped together.

The one way to see they are grouped is to look at the title bar and you will see the word ‘Grouped’, its not very clear is it, so I ALWAYS Ungroup the sheets once I have done my work and entered the data onto the sheets.. I call this BP..best practice or Barbara  Practice maybe…

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