+ Reply to Thread
Results 1 to 10 of 10

How to unsort my excel columns after save changes?

  1. #1
    RAFFI
    Guest

    How to unsort my excel columns after save changes?

    If I save changes to the excel file after sorting, I can't able to unsort it
    as original. Is there any option to do so in excel?

  2. #2
    Valued Forum Contributor
    Join Date
    06-30-2005
    Location
    Verwood, Dorset, England
    MS-Off Ver
    Excel 2000
    Posts
    479
    Quote Originally Posted by RAFFI
    If I save changes to the excel file after sorting, I can't able to unsort it
    as original. Is there any option to do so in excel?
    Hi Raffi

    Before sorting add an additional column numbered 1 - ?, you can the re-sort on that column
    Paul

  3. #3
    Joy
    Guest

    RE: How to unsort my excel columns after save changes?

    You cannot undo the sort after saving. The best to do before sorting, is to
    add an ID column with numbers running from 1. Then if you want to restore
    your sort, you can then sort on this column.

    "RAFFI" wrote:

    > If I save changes to the excel file after sorting, I can't able to unsort it
    > as original. Is there any option to do so in excel?


  4. #4
    Arvi Laanemets
    Guest

    Re: How to unsort my excel columns after save changes?

    Hi

    As sorting in Excel means overwriting all data in new order - definitely no!
    The only option is undo - which doesn't help you after you saved the file.


    --
    Arvi Laanemets
    ( My real mail address: arvil<at>tarkon.ee )



    "RAFFI" <[email protected]> wrote in message
    news:[email protected]...
    > If I save changes to the excel file after sorting, I can't able to unsort
    > it
    > as original. Is there any option to do so in excel?




  5. #5
    RAFFI
    Guest

    RE: How to unsort my excel columns after save changes?



    "Joy" wrote:

    > You cannot undo the sort after saving. The best to do before sorting, is to
    > add an ID column with numbers running from 1. Then if you want to restore
    > your sort, you can then sort on this column.
    >
    > "RAFFI" wrote:
    >
    > > If I save changes to the excel file after sorting, I can't able to unsort it
    > > as original. Is there any option to do so in excel?


  6. #6
    RAFFI
    Guest

    RE: How to unsort my excel columns after save changes?



    "Joy" wrote:

    > You cannot undo the sort after saving. The best to do before sorting, is to
    > add an ID column with numbers running from 1. Then if you want to restore
    > your sort, you can then sort on this column.
    >
    > "RAFFI" wrote:
    >
    > > If I save changes to the excel file after sorting, I can't able to unsort it
    > > as original. Is there any option to do so in excel?


  7. #7
    RAFFI
    Guest

    RE: How to unsort my excel columns after save changes?



    "RAFFI" wrote:

    >
    >
    > "Joy" wrote:
    >
    > > You cannot undo the sort after saving. The best to do before sorting, is to
    > > add an ID column with numbers running from 1. Then if you want to restore
    > > your sort, you can then sort on this column.
    > >
    > > "RAFFI" wrote:
    > >
    > > > If I save changes to the excel file after sorting, I can't able to unsort it
    > > > as original. Is there any option to do so in excel?


  8. #8
    RAFFI
    Guest

    Re: How to unsort my excel columns after save changes?



    "Arvi Laanemets" wrote:

    > Hi
    >
    > As sorting in Excel means overwriting all data in new order - definitely no!
    > The only option is undo - which doesn't help you after you saved the file.
    >
    >
    > --
    > Arvi Laanemets
    > ( My real mail address: arvil<at>tarkon.ee )
    >
    >
    >
    > "RAFFI" <[email protected]> wrote in message
    > news:[email protected]...
    > > If I save changes to the excel file after sorting, I can't able to unsort
    > > it
    > > as original. Is there any option to do so in excel?

    >
    >
    > Thank you for your reply,


    But I thought that there couldl be an index file that can be attached with
    the original file or any other supporting key file would generate
    simultaneoustly when we sort a columnn.

    thanks

  9. #9
    Arvi Laanemets
    Guest

    Re: How to unsort my excel columns after save changes?

    Hi

    Excel is a spreadsheet, not a database. There is no indexing built in - you
    can look at it as at a (selection of) big unstructured 2-dimesional table(s)
    (you can implement your own pseudo-structure of-course). It's strong side is
    calculating many formulas simultanously, and extreme design flexibility.


    --
    Arvi Laanemets
    ( My real mail address: arvil<at>tarkon.ee )



    "RAFFI" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "Arvi Laanemets" wrote:
    >
    >> Hi
    >>
    >> As sorting in Excel means overwriting all data in new order - definitely
    >> no!
    >> The only option is undo - which doesn't help you after you saved the
    >> file.
    >>
    >>
    >> --
    >> Arvi Laanemets
    >> ( My real mail address: arvil<at>tarkon.ee )
    >>
    >>
    >>
    >> "RAFFI" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > If I save changes to the excel file after sorting, I can't able to
    >> > unsort
    >> > it
    >> > as original. Is there any option to do so in excel?

    >>
    >>
    >> Thank you for your reply,

    >
    > But I thought that there couldl be an index file that can be attached
    > with
    > the original file or any other supporting key file would generate
    > simultaneoustly when we sort a columnn.
    >
    > thanks




  10. #10
    Registered User
    Join Date
    06-02-2015
    Location
    Europe
    MS-Off Ver
    2010
    Posts
    1

    Re: How to unsort my excel columns after save changes?

    In MS Excel 2010 version, To unsort multiple/many columns in excel at once in one go, go to the Ribbon: HOME->EDITING->SORT &FILTER drop down menu->CLEAR. This will clear all the columns/rows in the that Worksheet. HTH

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1