+ Reply to Thread
Results 1 to 5 of 5

ascending - descending

  1. #1
    Registered User
    Join Date
    06-16-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    ascending - descending

    If I typed data in descending, is there a way for me to copy-paste it so that it reads ascending, without having to re-type it all, or copy-pasting individual cells, etc?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: ascending - descending

    Select the data, Data > Sort, ...
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-16-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: ascending - descending

    Is it just me? Because I can't see this at all.
    That's what I had tried originally, thinking it would be obvious, but I can't for the life of me figure out where this function is.
    The data is not in numerical order, or else it would be quite easy to figure out.
    ex -
    I want
    Column A
    6
    8
    5
    2

    To read:
    Column A
    2
    5
    8
    6

    Thanks to anyone who can point me in the right direction! I'm making power consumption data spreadsheets involving thousands upon thousands of entries...
    Last edited by Bonnie WLU; 06-17-2009 at 08:44 AM. Reason: typo

  4. #4
    Registered User
    Join Date
    06-10-2009
    Location
    AC
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: ascending - descending

    go to data in the formula bar and click on sort - sorting will take care of numeric and alphanumeric category of sorting. please define

  5. #5
    Registered User
    Join Date
    06-10-2009
    Location
    AC
    MS-Off Ver
    Excel 2003
    Posts
    9

    Red face Re: ascending - descending

    i meant "go to data in the menu bar"

+ 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