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

G

Guest

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
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use macro to sort column 2
How do I sort the whole row at once in Excel? 2
Sorting after my worksheet has input I want to save 2
Select 'Sort By' column by simply typing heading letter 1
Grouping or joining rows 4
How to sort entire spreadsheet by one column sort 5
comparing more then one column with numbers and letters 1
Sort Date Column 3

Top