Sort protection unavailable


Tip
When attempting to sort data in Excel, the Sort option is sometimes unavailable. An area of Excel, containing number values and text, is selected, maybe 4 columns by 14 rows. Then when selecting Data--Sort the Sort option in the Data menu is greyed out.
One sure cause for this is that the sheet, or workbook, is protected. Disable protection and sorting will be available.

Category: Digital Helpline, Spreadsheet
Issue: Apr 1997
Pages: 184

These Web pages are produced by Australian PC World © 1997 IDG Communications