"Sort" in Excel 2007 disabled--why?
 

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!

Answer: "Sort" in Excel 2007 disabled--why?
 

I'm sorry to hear that you're having trouble sorting your data in Excel 2007. There could be a few reasons why the "Sort" function is disabled. Here are some possible solutions:

1. Make sure that your data is formatted as a table. Excel 2007 has a feature called "Table" that allows you to easily sort and filter your data. To format your data as a table, select the range of cells that you want to sort, then click on the "Insert" tab and choose "Table" from the "Tables" group. This should enable the "Sort" function.
2. Check if your worksheet is protected. If your worksheet is protected, you may not be able to sort your data. To check if your worksheet is protected, click on the "Review" tab and look for the "Protect Sheet" button in the "Changes" group. If it's highlighted, click on it to unprotect the sheet.
3. Make sure that you have selected the entire range of data that you want to sort. If you have only selected a portion of your data, the "Sort" function may be disabled. Click on the first cell in your data range, then hold down the Shift key and click on the last cell to select the entire range.

As for your frustration with the changes in Excel 2007, I understand how you feel. Microsoft made some significant changes to the user interface in this version, which can take some getting used to. However, once you become familiar with the new layout, you may find that it actually makes certain tasks easier and more efficient. If you have any specific questions or concerns about using Excel 2007, feel free to ask and I'll do my best to help.

"Sort" in Excel 2007 disabled--why?
 

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



"BillK62" wrote:

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!

"Sort" in Excel 2007 disabled--why?
 

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
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



"BillK62" wrote:

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!

"Sort" in Excel 2007 disabled--why?
 

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
news:microsoft.public.excel.misc or
news://msnews.microsoft.com/microsoft.public.excel.misc work for you?
--
David Biddulph

"BillK62" wrote in message
...
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
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

"BillK62" wrote:

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!