Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Data into columns without replacing the columns with data | New Users to Excel | |||
Select data from 1st of up to 6 columns & Xfering to other workshe | Excel Discussion (Misc queries) | |||
sorting data in columns | Excel Discussion (Misc queries) | |||
Select updated data from a range of columns | Excel Worksheet Functions | |||
Sorting two columns of data | Excel Worksheet Functions |