| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how many columns are included in a standard sort in Excel?
I have an Excel worksheet that is 34 columns wide. When I sorted the rows
(without highlighting it), only the first 24 columns got included in the sort. I save the data before realizing this happened so now my information is thoroughly messed up. Does anyone know why Excel didn't include all 34 columns? Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how many columns are included in a standard sort in Excel?
Jen
Excel takes a stab at the usedrange and this is normally the contiguous block of data emanating from the activecell. It is not uncommon for Excel to get this wrong, so selection is always the best course to avoid doubt. I suspect the data you have was seen as having gaps basically -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html "HawaiiJen" wrote in message ... I have an Excel worksheet that is 34 columns wide. When I sorted the rows (without highlighting it), only the first 24 columns got included in the sort. I save the data before realizing this happened so now my information is thoroughly messed up. Does anyone know why Excel didn't include all 34 columns? Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Are Hidden Rows/ Columns Included in a Sort? | Excel Discussion (Misc queries) | |||
| prevent column from being included in sort in Excel | Excel Discussion (Misc queries) | |||
| How to sort an Excel spreadsheet by more than 3 columns? | Excel Worksheet Functions | |||
| how do I sort several columns in excel | Excel Worksheet Functions | |||
| Header included in sort | Excel Worksheet Functions | |||
Linear Mode
