Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What does the '[Group]' label in the Excel title bar mean?
Hello,
I have a spreadsheet which has [Group] in the title bar. I can't create charts, can't run other tools. I can't figure out how it got there, nor how to get rid of it. I have resaved, but still can't figure it out. Any hints appreciated. --LEon |
#2
|
|||
|
|||
The [Group] indicator means that you have more than one sheet is
selected; the sheets are "grouped". When this is the case, a change made to one sheet is made to all the grouped sheets. Right-click on the sheet tab and choose "Ungroup Sheets" to ungroup the sheets. "Leon Brown" <Leon wrote in message ... Hello, I have a spreadsheet which has [Group] in the title bar. I can't create charts, can't run other tools. I can't figure out how it got there, nor how to get rid of it. I have resaved, but still can't figure it out. Any hints appreciated. --LEon |
#3
|
|||
|
|||
The [Group] means that you have more than 1 sheet selected. Right click on a
tab in that workbook and click ungroup sheets. "Leon Brown" wrote: Hello, I have a spreadsheet which has [Group] in the title bar. I can't create charts, can't run other tools. I can't figure out how it got there, nor how to get rid of it. I have resaved, but still can't figure it out. Any hints appreciated. --LEon |
#4
|
|||
|
|||
Thanks Chip, David. That worked.
--Leon "Chip Pearson" wrote: The [Group] indicator means that you have more than one sheet is selected; the sheets are "grouped". When this is the case, a change made to one sheet is made to all the grouped sheets. Right-click on the sheet tab and choose "Ungroup Sheets" to ungroup the sheets. "Leon Brown" <Leon wrote in message ... Hello, I have a spreadsheet which has [Group] in the title bar. I can't create charts, can't run other tools. I can't figure out how it got there, nor how to get rid of it. I have resaved, but still can't figure it out. Any hints appreciated. --LEon |
#5
|
|||
|
|||
Hi Leon,
When sheets are grouped whatever text/values are typed into one sheet also show in all the other sheets in the group. This also includes all the formatting applied such as column widths, fonts, etc., so it's pretty handy. [Group] shows in the title bar whenever any or all sheets are in group mode. To undo group, right-click on any sheet label, and choose "Ungroup sheets". It's pretty easy to put sheets in group mode by mistake just by clicking once on the first sheet name, holding your shift key, then clicking the last sheet name. HTH "Leon Brown" wrote: Hello, I have a spreadsheet which has [Group] in the title bar. I can't create charts, can't run other tools. I can't figure out how it got there, nor how to get rid of it. I have resaved, but still can't figure it out. Any hints appreciated. --LEon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My Y-axis label is cut off in Excel charts | Charts and Charting in Excel | |||
can you make a title page using Excel? | Excel Worksheet Functions | |||
How to leave the title row in MS Excel fixed? | Excel Worksheet Functions | |||
My Excel Title bar does not indicate what file is open | Excel Discussion (Misc queries) | |||
The x-axis title is truncated in EXCEL charts 2003. | Charts and Charting in Excel |