| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ungrouping
I have a spreadsheet that is grouped, and I want to ungroup it. I have
selected the spreadsheet and tried using the Draw toolbar, but the Ungroup option is not highlighted for me to use. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ungrouping
From the XL menu select Data - Group and Outline - Ungroup
-- HTH... Jim Thomlinson "Brad H" wrote: I have a spreadsheet that is grouped, and I want to ungroup it. I have selected the spreadsheet and tried using the Draw toolbar, but the Ungroup option is not highlighted for me to use. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ungrouping
Ungroup is not highlighted to click on.
"Jim Thomlinson" wrote: From the XL menu select Data - Group and Outline - Ungroup -- HTH... Jim Thomlinson "Brad H" wrote: I have a spreadsheet that is grouped, and I want to ungroup it. I have selected the spreadsheet and tried using the Draw toolbar, but the Ungroup option is not highlighted for me to use. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ungrouping
Hi,
If the sheets are grouped the right click sheet tab and pick ungroup. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Brad H" wrote in message ... Ungroup is not highlighted to click on. "Jim Thomlinson" wrote: From the XL menu select Data - Group and Outline - Ungroup -- HTH... Jim Thomlinson "Brad H" wrote: I have a spreadsheet that is grouped, and I want to ungroup it. I have selected the spreadsheet and tried using the Draw toolbar, but the Ungroup option is not highlighted for me to use. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ungrouping
If the Worksheet is labeled [Group], R-click the sheet tab and select
"Ungroup Sheets" Brad H wrote: Ungroup is not highlighted to click on. "Jim Thomlinson" wrote: From the XL menu select Data - Group and Outline - Ungroup -- HTH... Jim Thomlinson "Brad H" wrote: I have a spreadsheet that is grouped, and I want to ungroup it. I have selected the spreadsheet and tried using the Draw toolbar, but the Ungroup option is not highlighted for me to use. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ungrouping a Bar Chart | Charts and Charting in Excel | |||
| Missing Rows after Ungrouping | Excel Discussion (Misc queries) | |||
| ungrouping clip art | Excel Discussion (Misc queries) | |||
| After grouping & ungrouping a chart, I can no longer format it? | Charts and Charting in Excel | |||
| Slow grouping and ungrouping since update | Excel Discussion (Misc queries) | |||
Linear Mode
