Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |