![]() |
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. |
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. |
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. |
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 |
All times are GMT +1. The time now is 08:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com