| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Sort
I have a database of four columns. The first column is product type and the
second column is client name. The first product type consumes approximately the first 20 rows. If I wanted to just sort those first twenty clients alphabetically w/o affecting the rest of the data can I do that? or does the entire table have to be sorted? Thank you in advance for your assistance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Sort
If you select more than one cell, Excel will sort the selection. Otherwise
it will sort the current region. Therefore, select A1:A20 (or whatever the range is you want to sort). "SJT" wrote in message ... I have a database of four columns. The first column is product type and the second column is client name. The first product type consumes approximately the first 20 rows. If I wanted to just sort those first twenty clients alphabetically w/o affecting the rest of the data can I do that? or does the entire table have to be sorted? Thank you in advance for your assistance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Sort
Thank you for your hlep.
"Bob Umlas" wrote: If you select more than one cell, Excel will sort the selection. Otherwise it will sort the current region. Therefore, select A1:A20 (or whatever the range is you want to sort). "SJT" wrote in message ... I have a database of four columns. The first column is product type and the second column is client name. The first product type consumes approximately the first 20 rows. If I wanted to just sort those first twenty clients alphabetically w/o affecting the rest of the data can I do that? or does the entire table have to be sorted? Thank you in advance for your assistance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Sort
I never let excel guess what I want sorted. I always explicitly select the
range. SJT wrote: I have a database of four columns. The first column is product type and the second column is client name. The first product type consumes approximately the first 20 rows. If I wanted to just sort those first twenty clients alphabetically w/o affecting the rest of the data can I do that? or does the entire table have to be sorted? Thank you in advance for your assistance. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort on data field | Excel Discussion (Misc queries) | |||
| sort source workbook data, maintain formulas in destination workb. | Excel Worksheet Functions | |||
| Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
| macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
| sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
