jerome

Distinguished
May 17, 2002
56
0
18,630
Archived from groups: microsoft.public.windowsxp.help_and_support (More info?)

I sorted the columns in one sheet and continued working on other sheets.
Now I want to undo the sorting but it just let's me undo the 5 last actions.
How can I have the columns sorted in the original order.
Thanks, J
 
G

Guest

Guest
Archived from groups: microsoft.public.windowsxp.help_and_support (More info?)

Um, close without saving and then reopen the file. Even with undo, any
typing changes would be lost since Excel doesn't have a selective undo
feature.


"Jerome" <mprranch@ntin.net> wrote in message
news:C7B30510-714B-49DD-BD75-D6F330DEDE47@microsoft.com...
> I sorted the columns in one sheet and continued working on other sheets.
> Now I want to undo the sorting but it just let's me undo the 5 last
actions.
> How can I have the columns sorted in the original order.
> Thanks, J
>
 
G

Guest

Guest
Archived from groups: microsoft.public.windowsxp.help_and_support (More info?)

there are sort options in excel.. try the excel ng, those ppl are wizards
with excel manipulations

microsoft.public.excel

--
"Display tolerance & kindness to those with less
knowledge than you because there is ALWAYS
someone with more"


"Jerome" <mprranch@ntin.net> wrote in message
news:C7B30510-714B-49DD-BD75-D6F330DEDE47@microsoft.com...
> I sorted the columns in one sheet and continued working on other sheets.
> Now I want to undo the sorting but it just let's me undo the 5 last
actions.
> How can I have the columns sorted in the original order.
> Thanks, J
 

Tom

Distinguished
Dec 31, 2007
1,720
0
19,780
Archived from groups: microsoft.public.windowsxp.help_and_support (More info?)

Umm, Excel does too have an Undo selection feature.

"LVTravel" <trash@dd.com> wrote in message
news:112erhlktaddobb@corp.supernews.com...
> Um, close without saving and then reopen the file. Even with undo, any
> typing changes would be lost since Excel doesn't have a selective undo
> feature.
>
>
> "Jerome" <mprranch@ntin.net> wrote in message
> news:C7B30510-714B-49DD-BD75-D6F330DEDE47@microsoft.com...
>> I sorted the columns in one sheet and continued working on other sheets.
>> Now I want to undo the sorting but it just let's me undo the 5 last
> actions.
>> How can I have the columns sorted in the original order.
>> Thanks, J
>>
>
>
>
 
G

Guest

Guest
Archived from groups: microsoft.public.windowsxp.help_and_support (More info?)

Which versions? I am using Excel in Office 97 and it does not have a
selective undo that I can find, only a straight line undo. Maybe later
versions of Office does allow selective Undo (but with a spread sheet I
don't know that I would want to start screwing around with data in a random
order fashion.)
"Tom" <noway@nothere.com> wrote in message
news:erkpgXDIFHA.1280@TK2MSFTNGP09.phx.gbl...
> Umm, Excel does too have an Undo selection feature.
>
> "LVTravel" <trash@dd.com> wrote in message
> news:112erhlktaddobb@corp.supernews.com...
> > Um, close without saving and then reopen the file. Even with undo, any
> > typing changes would be lost since Excel doesn't have a selective undo
> > feature.
> >
> >
> > "Jerome" <mprranch@ntin.net> wrote in message
> > news:C7B30510-714B-49DD-BD75-D6F330DEDE47@microsoft.com...
> >> I sorted the columns in one sheet and continued working on other
sheets.
> >> Now I want to undo the sorting but it just let's me undo the 5 last
> > actions.
> >> How can I have the columns sorted in the original order.
> >> Thanks, J
> >>
> >
> >
> >
>
>
>
 

Tom

Distinguished
Dec 31, 2007
1,720
0
19,780
Archived from groups: microsoft.public.windowsxp.help_and_support (More info?)

I use Office XP at work, and Office 2003 here at home, and they can do what
the OP needs. but before you make blanket statements, you should consider
what version you are *only* familiar with before telling another what can
and cannot be done. Maybe suggest by saying you are unsure of other
versions, but "mine doesn't".

"LVTravel" <trash@dd.com> wrote in message
news:112hdesk686jsd5@corp.supernews.com...
> Which versions? I am using Excel in Office 97 and it does not have a
> selective undo that I can find, only a straight line undo. Maybe later
> versions of Office does allow selective Undo (but with a spread sheet I
> don't know that I would want to start screwing around with data in a
> random
> order fashion.)
> "Tom" <noway@nothere.com> wrote in message
> news:erkpgXDIFHA.1280@TK2MSFTNGP09.phx.gbl...
>> Umm, Excel does too have an Undo selection feature.
>>
>> "LVTravel" <trash@dd.com> wrote in message
>> news:112erhlktaddobb@corp.supernews.com...
>> > Um, close without saving and then reopen the file. Even with undo, any
>> > typing changes would be lost since Excel doesn't have a selective undo
>> > feature.
>> >
>> >
>> > "Jerome" <mprranch@ntin.net> wrote in message
>> > news:C7B30510-714B-49DD-BD75-D6F330DEDE47@microsoft.com...
>> >> I sorted the columns in one sheet and continued working on other
> sheets.
>> >> Now I want to undo the sorting but it just let's me undo the 5 last
>> > actions.
>> >> How can I have the columns sorted in the original order.
>> >> Thanks, J
>> >>
>> >
>> >
>> >
>>
>>
>>
>
>
>