ExcelBanter - Data Sort Option greyed.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Sort Option greyed. (https://www.excelbanter.com/excel-discussion-misc-queries/223804-data-sort-option-greyed.html)

Janean@UT Austin Hook EM

Data Sort Option greyed.

I have been using this spreadsheet and all of sudden I cannot data sort. The
function is greyed out.

Elkar

Data Sort Option greyed.

Did your worksheet become "Protected"?

In Excel 2003 or earlier: TOOLS--OPTIONS--Unprotect Sheet

In Excel 2007: Go to the Review Tab, then click "Unprotect Sheet"

HTH
Elkar

"Janean@UT Austin Hook EM" wrote:

I have been using this spreadsheet and all of sudden I cannot data sort. The
function is greyed out.

All times are GMT +1. The time now is 07:17 AM.