Sort Rows by Value in a Column
 

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

Sort Rows by Value in a Column
 

Is this column in a List in xl2003? If not, double clicking on a column
header doesn't sort that I am aware of.

--
Regards,
Tom Ogilvy




"Emily" wrote:

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

Sort Rows by Value in a Column
 

Hi Tom,

What do you mean by "this column in a List in xl2003"?

-Emily

Sort Rows by Value in a Column
 

Since you don't know, you have to select the data and do Data=Sort and
select the column you want to sort on.

--
Regards,
Tom Ogilvy

"Emily" wrote in message
ups.com...
Hi Tom,

What do you mean by "this column in a List in xl2003"?

-Emily