How do I sort by info in one column and it stay in line with info
 

I am doing a spreadsheet with several columns...I want to sort the rows by
info in a certain column...I want each rows' info to stay in line while i
sort by that certain column...can this be done? Also more than 1 column
contains numbers and the column I want to sort by contains dates..I dont want
to sort by the other numbers in different columns...please advise

How do I sort by info in one column and it stay in line with info
 

Just make sure you select all the columns to be in the sort range before
DataSort and picking the column(dates column) to sort on.


Gord Dibben MS Excel MVP

On Fri, 9 Mar 2007 14:33:08 -0800, stephanie <stephanie
@discussions.microsoft.com wrote:

I am doing a spreadsheet with several columns...I want to sort the rows by
info in a certain column...I want each rows' info to stay in line while i
sort by that certain column...can this be done? Also more than 1 column
contains numbers and the column I want to sort by contains dates..I dont want
to sort by the other numbers in different columns...please advise

How do I sort by info in one column and it stay in line with i
 

Thank you very much!! That works great!!!

"Gord Dibben" wrote:

Just make sure you select all the columns to be in the sort range before
DataSort and picking the column(dates column) to sort on.


Gord Dibben MS Excel MVP

On Fri, 9 Mar 2007 14:33:08 -0800, stephanie <stephanie
@discussions.microsoft.com wrote:

I am doing a spreadsheet with several columns...I want to sort the rows by
info in a certain column...I want each rows' info to stay in line while i
sort by that certain column...can this be done? Also more than 1 column
contains numbers and the column I want to sort by contains dates..I dont want
to sort by the other numbers in different columns...please advise