Group & Ungroup Worksheets in Excel

This video demonstrates how to group and ungroup worksheets in an Excel workbook.

- how to group consecutive worksheets
- how to group non-consecutive worksheets
- how to ungroup worksheets

Everything you do in one grouped worksheet is applied to the other grouped worksheets. This would include, formatting, adding data and removing data.
------------------------

[camcab]

Ooh! This sounds like what's happened to me on my spreadsheet! I entered some information say, in line 11 on TAB B and later on realised that the same information appeared on the same line in TAB A, TAB C, TAB D etc. When I tried to delete it from one of the other tabs (prior to realising the information was elsewhere, too), it deleted the original information from TAB B which is where I wanted it. Luckily I was able to undo that as I hadn't saved the info. However, it looks like when this information was duplicated in other tabs, it's removed the information that had occupied line 11 in the other tabs. I wonder how I can stop the duplication.

[ntsikelelomaqubela]

Thank you. However when I enter a paste column values copied from another excel file in one of the sheets, even though I no longer want the sheets grouped, the other sheets are populated too. How do I disable this feature?
Sorry, just noticed that the excel I'm copying from also had grouped sheets. When I disabled that grouping, the data wasn't pasted throughout the other sheets in my new excel file.