Select all columns with data for sorting.

  • Thread starter Thread starter jen907
  • Start date Start date
J

jen907

When selecting columns for sorting, is there a way to make it so it
automatically selects all columns with data in them? Say you have data in
columns A-T but accidentally only select A-S, and then sort it, but didn't
realize you hadn't selected all of the columns. That last column is no longer
correct, but you don't know it.

Sorry if this doesn't make sense, I'm trying to figure it out to help my
boss and I'm stuck.
 
Hi,

better yet, if your data is contiguous with no none data touching it and 1
row of titles, you don't need to select the range at all, just put your
cursor in any single cell of the data and choose Data, Sort...

Also, you can select all contiguous data by press Ctrl+A or Ctrl+* or
Ctrl+Shit+Spacebar while you are in any single cell or part of the data range.

Depending on the version Excel sometimes asks if you want to extend the sort
range if it determines there is contiguous none selected data.
 
It's Excel 2007, and sometimes there are columns that are blank (I don't know
why). He said he uses Ctrl + A, and it doesn't always select all of the data.
 
Back
Top