L
Lou E
I performed a sort. now I am stuck with the original sort and can not change
to a different range. How to remove the original range?
to a different range. How to remove the original range?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Rech
Ok, I'll bite. As far as I know, with manual sorts, Excel always operates
on the current selection or an expansion of the current selection. I do not
believe Excel retains any memory of the last range sorted. Maybe you can
elaborate on exactly what you're seeing, say an example that we could
recreate.
on the current selection or an expansion of the current selection. I do not
believe Excel retains any memory of the last range sorted. Maybe you can
elaborate on exactly what you're seeing, say an example that we could
recreate.
I
Interforo
Jim Rech said:Ok, I'll bite. As far as I know, with manual sorts, Excel always operates
on the current selection or an expansion of the current selection. I do not
believe Excel retains any memory of the last range sorted. Maybe you can
elaborate on exactly what you're seeing, say an example that we could
recreate.
--
Jim
|I performed a sort. now I am stuck with the original sort and can not
change
| to a different range. How to remove the original range?
I
Interforo
had Lou's same problem, but I found how to fix this . If you have applied a
design to your spreadsheet as a table, when you are sorting Excel assumes the
range of the whole table. To remove that range you would have to click on
"Convert to Range" to eliminate the old one. After that you should be able to
use the Sort function using any range.
design to your spreadsheet as a table, when you are sorting Excel assumes the
range of the whole table. To remove that range you would have to click on
"Convert to Range" to eliminate the old one. After that you should be able to
use the Sort function using any range.