Ask a new question

Excel Title Bar [Group]

In the Excel Title Bar the word "[Group]" has appeared after the file name and the options of the DATA tab is unavailable. How was the added and how can it be removed so that the option in the DATA tab are available.
Answer
Answer
If you have more than one sheet tab selected at the same time...
Example:
• Select Sheet1
• Hold down the CTRL key and select Sheet3
...Now that both sheets are selected, [Group] displays

That is Excel's way of warning you that any change you make
to one of the selected sheets will ALSO be made to the other selected sheets.

When sheets are grouped, the DATA menu items that are disabled apply to
a specific sheet.  Consequently, they can not be implemented to grouped sheets.

To UN-group the sheets:
• Right-click on the sheet tab....Select: Ungroup.

Does that help?
Ron Coderre
Microsoft MVP - Excel (2006 - 2010)

P.S. If any post answers your question, please mark it as the Answer
(That way it won't keep showing as an open item.)
Regards,

Ron Coderre
Former Microsoft MVP - Excel

158 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer

For more information, click on the Microsoft link below and check the ‘Tip’ section. The ‘Tip’ section provides information on ‘Group’ and ‘Ungroup Sheets’.

http://office.microsoft.com/en-us/excel/HP052024921033.aspx

8 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated March 22, 2024 Views 43,280 Applies to: