Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't select/edit objects. It says [Group] on the header bar.
I have a chart in a worksheet which until yesterday I was able to edit and
move around. Now I can't even select it, much less edit it. Insert Symbol, Chart, and Comment are all suddenly greyed out all the time. On the header bar, after the name of the file, it says [Group]. What have I done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't select/edit objects. It says [Group] on the header bar.
You have selected more than one worksheet. Right-click tab for the
currently active sheet (the one you are looking at) in the lower left of the Excel window and click Ungroup. You can also click a sheet tab that appears gray instead of white. Then, click back to the sheet you want to edit. So you know in the future, if you press either Ctrl or Shift when you click a sheet tab, you will select multiple sheet, and this creates a Group. -- tj "Tomba" wrote: I have a chart in a worksheet which until yesterday I was able to edit and move around. Now I can't even select it, much less edit it. Insert Symbol, Chart, and Comment are all suddenly greyed out all the time. On the header bar, after the name of the file, it says [Group]. What have I done? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't select/edit objects. It says [Group] on the header bar.
Hi
You have two or more sheets grouped. Right click on the tab of the sheet and left click on Ungroup Sheets. Any alterations you have made while the sheets have been grouped will have been made to ALL grouped sheets. Andy. "Tomba" wrote in message ... I have a chart in a worksheet which until yesterday I was able to edit and move around. Now I can't even select it, much less edit it. Insert Symbol, Chart, and Comment are all suddenly greyed out all the time. On the header bar, after the name of the file, it says [Group]. What have I done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Header Rows and Sort Issue | Excel Discussion (Misc queries) | |||
Assigning VB to Grouped Objects | Excel Discussion (Misc queries) | |||
How do I setup a header in Excel that prints only on first page? | Excel Discussion (Misc queries) | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) | |||
Default header in Excel under page set-up | Excel Discussion (Misc queries) |