Sort Rows by Value in a Column

  • Thread starter Thread starter Emily
  • Start date Start date
E

Emily

Hi,

I have a spreadsheet with a column of boolean data (either TRUE or
FALSE). I'll need to sort the rows by this boolean value (so that I can
delete a chunk of rows whose value in this column is FALSE and keep
those rows those value in this column is TRUE).

Howver, when I double-click on the header of this boolean column,
nothing happened (they rows are not sorted). Any advice on how to sort?


-Emily
 
Is this column in a List in xl2003? If not, double clicking on a column
header doesn't sort that I am aware of.
 
Since you don't know, you have to select the data and do Data=>Sort and
select the column you want to sort on.
 
Back
Top