Select all columns with data for sorting.
 

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.

Select all columns with data for sorting.
 

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+****+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.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"jen907" wrote:

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.

Select all columns with data for sorting.
 

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.

"Shane Devenshire" wrote:

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+****+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.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"jen907" wrote:

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.