| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting data and expanding the selection
I am trying to sort data in colum B using the Z-A function on an imported
data dase, however the selection is only expanding to coulm S when I click on the Z-A function, my data range is B2 : AG28324 any ideas welcome -- Chris |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting data and expanding the selection
Hi
The general view on this forum is not to use the A-Z or Z-A buttons - ever! Manually select the range you want to sort and use Data/Sort. Andy. "Barnet1" wrote in message ... I am trying to sort data in colum B using the Z-A function on an imported data dase, however the selection is only expanding to coulm S when I click on the Z-A function, my data range is B2 : AG28324 any ideas welcome -- Chris |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting data and expanding the selection
Problem solved
Many thanks Chris -- Chris "Barnet1" wrote: I am trying to sort data in colum B using the Z-A function on an imported data dase, however the selection is only expanding to coulm S when I click on the Z-A function, my data range is B2 : AG28324 any ideas welcome -- Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expanding data | Excel Worksheet Functions | |||
| Copying range format and formulae without data | Excel Discussion (Misc queries) | |||
| Expanding Data validation from List | Excel Discussion (Misc queries) | |||
| Linked query not expanding with new data | Excel Worksheet Functions | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
Linear Mode
