sorting in excel

[Aaron Chupp]

i have been working on a spread sheet of data for about 5
months. today i am trying to change some of the
formating as update entries. in the past i would sort
the data in this worksheet using the sort option under
the data menu. Suddenly today the data menu only has the
options, "Filter, Group and Outline, and Import External
Data." The rest of the options have been ghosted and do
not work.
I tried copying and pasting into a new document. But as
soon as i do that the document no longer has the option
of sorting.
Has some setting been changed? What do i do?

 

[Frank Kabel]

Hi
is your worksheet protected or is it a shared worksheet?

 

[Aaron]

How do I figure that out?

-----Original Message-----
Hi
is your worksheet protected or is it a shared worksheet?

--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[Frank Kabel]

Hi
Protection: goto 'Tools - Protection'. Is there an option to unprotect
the worksheet?

Sharing: Does the word 'Group' appear in the title bar

 

[Guest]

yes, it is shared. what does that mean?

-----Original Message-----
Hi
Protection: goto 'Tools - Protection'. Is there an option to unprotect
the worksheet?

Sharing: Does the word 'Group' appear in the title bar


--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[Frank Kabel]

You're not allowed to sort in a shared workbook (one of the
restrictions of shared workbooks)

 

[Debra Dalgleish]

If you see the word [Group] in the title bar, it means that more than
one sheet is currently selected.

If you look at the sheet tabs, two or more of them are white, instead of
grey, and the active sheet has bold letters on the tab.

To ungroup them, so you can sort again, right-click on a sheet tab, and
choose Ungroup sheets

 

[Guest]

Thank you both. It works now!

-----Original Message-----
If you see the word [Group] in the title bar, it means that more than
one sheet is currently selected.

If you look at the sheet tabs, two or more of them are white, instead of
grey, and the active sheet has bold letters on the tab.

To ungroup them, so you can sort again, right-click on a sheet tab, and
choose Ungroup sheets

yes, it is shared. what does that mean?




option to unprotect

about 5

has the

But as

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.