<div>
Maybe the sheet is protected, if it is you can not use some buttons. Try unprotecting it
</div>


Maybe the sheet is protected, if it is you can not use some buttons. Try unprotecting it

<div>
Is there no protection of the worksheet?<br />
<br />
Ed
</div>


Is there no protection of the worksheet?

Ed

<div>
If you accidentally grouped your worksheets, Sorting would not be available as well. Check it and ungroup worksheets if needed.<br />
<br />
Ed
</div>


If you accidentally grouped your worksheets, Sorting would not be available as well. Check it and ungroup worksheets if needed.

Ed

<div>
Hi there,<br />
<br />
I can't see that Grouping is enabled, I've tried selecting all and ungrouping makes no difference.<br />
<br />
There was filtering but that doesn't seem to make any difference, the weird this is that cells A,B,C and D weren't filtered and the rest had filters so there is some formatting / grouping somehow - is there a way to revert it all to off?
</div>


Hi there,

I can't see that Grouping is enabled, I've tried selecting all and ungrouping makes no difference.

There was filtering but that doesn't seem to make any difference, the weird this is that cells A,B,C and D weren't filtered and the rest had filters so there is some formatting / grouping somehow - is there a way to revert it all to off?

<div>
<div class="content wysiwyg-content">
Hi there,<br />
<br />
I have an excel spreadsheet with various columns including a date, and some custom formatted columns.<br />
<br />
Excel 2007 allowed me to sort this, but Excel 2010 greys out the sort button and I'm not sure why - any pointers!?<br />
<br />
M
</div>
</div>


Hi there,

I have an excel spreadsheet with various columns including a date, and some custom formatted columns.

Excel 2007 allowed me to sort this, but Excel 2010 greys out the sort button and I'm not sure why - any pointers!?

M

Excel Sorting Problem

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.