+ Reply to Thread
Results 1 to 6 of 6

Change all data from top to bottom and sort rows

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    93

    Change all data from top to bottom and sort rows

    Happy new year to everyone,

    I have a few hundred rows of data in 7 columns in which I want to turn it all upside down. How do I do that?

    I also need to sort the same rows of data from smallest to largest (left to right) but the "Sort" function in Excel 97 only allow me to perform a row at a time. Is their a way it can perform all rows in one go?

    Many thanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Change all data from top to bottom and sort rows

    Fill a simple sequence 1, 2, 3, etc down the 8th column. Then sort using that column in descending order.

    Have you really got XL 97 ? In your profile it says XL2007.

    Hope this helps.

    Pete

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Change all data from top to bottom and sort rows

    Something wrong today - the above post does not appear in my UserCP list.

    Pete

  4. #4
    Registered User
    Join Date
    12-14-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Change all data from top to bottom and sort rows

    Hi Pete,

    Sorry I took so long to reply. I actually thought no one reply to me because I normally get an e-mail notification. I don't know about your UserCP list. Anyone, typing error, I have 2007.

    I try your suggestion but I can only find sort smallest to largest vice versa . My data are ramdom. Their must be a way. Help!

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Change all data from top to bottom and sort rows

    In the Sort Order box you have a pull-down arrow - click on this to select Largest to Smallest.

    Hope this helps.

    Pete

  6. #6
    Registered User
    Join Date
    12-14-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Change all data from top to bottom and sort rows

    Hi Pete,

    Brilliant as usual. All sorted thanks.

    Take care

+ 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