"Sort" in Excel 2007 disabled--why?

[Guest]

I have two columns that I want to sort. Unfortunately, stupid Excel 2007 has
"Sort & Filter" on the "Home" ribbon, and everything on the "Data" ribbon
disabled. Why can't I sort?

And why on earth did Microsoft move everything around. Nothing works like it
used to. It's so very frustrating!

 

[Guest]

Check if you have more than one worksheet selected. If so, click on the tab
of an unselected sheet or if all selected, click on any tab.

(Multiple sheets are selected by holding Ctrl key and clicking on another
sheet.)

Regards,

OssieMac

 

[Guest]

I found out the problem: Excel had the label "[Group]" in the header. I
looked that up on this forum and found that I had to right click the sheet
tab and select "Ungroup".

Talk about this new Office being so totally unintuitive! I've used Excel for
more than a decade, I'm a computer programmer, and yet this new Office from
Microsoft has all of this hidden little quirks that are incredibly
frustrating. What was Microsoft thinking?

And if that weren't enough: trying to find this silly board to check and
post and reply to messages is a pain in the butt.



Mac" wrote:> Check if you have more than one worksheet selected. If so,
click on the tab

 

[David Biddulph]

The ability to group worksheets isn't new to Excel 2007. It's been there
for ages.

And as for finding "this board", many of us would recommend that you avoid
Microsoft's web interface to the newsgroup, and that you access the
newsgroup directly through NNTP. Does the link
or
news://msnews.microsoft.com/microsoft.public.excel.misc work for you?
--
David Biddulph

I found out the problem: Excel had the label "[Group]" in the header. I
looked that up on this forum and found that I had to right click the sheet
tab and select "Ungroup".

Talk about this new Office being so totally unintuitive! I've used Excel
for
more than a decade, I'm a computer programmer, and yet this new Office
from
Microsoft has all of this hidden little quirks that are incredibly
frustrating. What was Microsoft thinking?

And if that weren't enough: trying to find this silly board to check and
post and reply to messages is a pain in the butt.