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

S

stephanie

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
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 
S

stephanie

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

Gord Dibben said:
Just make sure you select all the columns to be in the sort range before
Data>Sort and picking the column(dates column) to sort on.


Gord Dibben MS Excel MVP
Click to expand...
 
Top