Grouping and un-grouping of worksheets in Excel

Asked By abrahamahartman 60 points N/A Posted on - 11/29/2014

I would like to edit multiple worksheets in MS Excel at the same time. My job requires that I insert values into multiple worksheets or delete a set of values from each one of them. Can I group worksheets together and edit them simultaneously? How is this done? Once I have finished editing, how can I then Ungroup the worksheets?

 

• Status: Open
• Question Views: 846
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Derick Harris 0 points N/A #200147

Grouping and un-grouping of worksheets in Excel

Hi Abrahamahartman,

You need to go through following steps to Group worksheets:

If you have three worksheets say worksheet A, B, C in an Excel file, then you need to press the CTRL key in keyboard and you need to hold that key. Holding CTRL key you need to click each tab you want to group, like in the example press CTRL key and hold and then click worksheet A, then B and after that click C sheet. You will see in the menu bar, the file name is showing with headline group with it. That means the worksheets are now grouped. Now if you enter something or delete something row wise or column wise or in any specific tab on Sheet A it will be affected on Sheet B and C also.

To un group worksheets, just click on a sheet after entering multiple records on every sheet. On click all worksheets will be ungrouped.      

Regards,

Derick Harris    

About Derick Harris

Questions
0

Answers
27

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 11/29/2014
• Question Category: MS Excel