Question on Sorting by (date, etc)

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I have a column (A) which sre dates.
If I select the column heading and click either the sort ascending or
desending button, the date column alone sorts independent of the other eight
columns that comprise the entire entry.
How would I go about being able to sort by a particular column and have
everything sort with it?
I have other columns that I would like to sort by sometimes too, like
"color", "type", etc.

Thanks for reading!
 
Try selecting any value in column A instead of the whole column, then click
the sort icon.
 
I never let Excel guess my sort range.

You can have a blank column that is hidden or very narrow and Excel will
stop at that column and not include columns to the left or right of that.

Select all columns before sorting.


Gord Dibben MS Excel MVP
 
You are correct. I should not have assumed the user is aware that sort stops
at the first blank column.

The tried and true method:

- Highlight area requiring sort
- Click 'Data', 'Sort'
- Choose your options

Be careful of the option whether to choose "my data range has" Header row /
No header row.

If you get it wrong press [Ctrl]/Z and try again.
 
1.Select all the column that have data
2.Click in data>sort from menubar
3.From sort by drop down list select column A
4.Ckeck the ascending option and click ok
Now you got all the columns sorted by column A



Chris
 
Back
Top