Grouping

C

Carolyn Malcoun

Hi everyone,

I have no idea how this happened, but I grouped all the worksheets in my
spreadsheet together. The Size, Rotation and Ordering tab is not showing up
in my formatting palette (I even tried de and reselecting it under the
customization tab and it's still not there). When I go to
Data>Group/Outline, the options are grayed out no matter what I have
selected.

I can't do anything with it; I can't even copy and paste the information
into a new spreadsheet to start over. Anyone have any remedies?

Thanks, carolyn
 
J

JE McGimpsey

Carolyn Malcoun said:
Hi everyone,

I have no idea how this happened, but I grouped all the worksheets in my
spreadsheet together. The Size, Rotation and Ordering tab is not showing up
in my formatting palette (I even tried de and reselecting it under the
customization tab and it's still not there). When I go to
Data>Group/Outline, the options are grayed out no matter what I have
selected.

I can't do anything with it; I can't even copy and paste the information
into a new spreadsheet to start over. Anyone have any remedies?
Click to expand...

CTRL-Click one of the worksheet tabs and choose UnGroup.

Grouping of worksheets happens when you hold the shift or command keys
down when selecting sheets.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
How to make scroll bar permanently visible, Word 365 0
Grouping worksheets 1
Word 2016 - Difficulties Learning Style Creation/Application 0
group 1
Size Rotation and ordering missing 3
Option Groups: Can I Group the Buttons AND the Box They're In? 2
Alt Tab and Multiple Spreadsheets 3

Top