+ Reply to Thread
Results 1 to 3 of 3

How can I arrange numbers in ascending order but....

  1. #1
    Registered User
    Join Date
    12-04-2007
    Posts
    13

    How can I arrange numbers in ascending order but....

    Hey guys, please see the attached screenshot of some keywords I am working on. I need to have the rows in ascending order of the B column numbers, I found instructions for that here:

    https://www.google.com/#q=excel+number+ascending+order

    but I am worried only the B column will change, I will need the entire rows to change accordingly too, how can I do this please?
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: How can I arrange numbers in ascending order but....

    Highlight the 3 columns, click Data>Sort and Sort on Column B.

    This will sort all 3 columns.

    EDIT: What I would recommend in these cases though is to play with it, either create a test spreadsheet or take a copy of you real one and try things. See if it works, if it doesnt do what you expected, close without saving and try again.
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    12-04-2007
    Posts
    13

    Re: How can I arrange numbers in ascending order but....

    That works, thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Arrange cells in ascending order
    By pankaj221 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-28-2016, 04:42 PM
  2. Arrange data in ascending order
    By bezbid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-17-2016, 10:22 AM
  3. [SOLVED] any way to arrange the categories on a bar chart by ascending/descending order
    By tukae in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-26-2015, 08:01 AM
  4. how to arrange multiple columns in ascending order
    By sanjay2210.msl in forum Excel General
    Replies: 2
    Last Post: 10-29-2013, 08:26 AM
  5. Arrange the sheet name in ascending order
    By PRADEEPB270 in forum Excel General
    Replies: 2
    Last Post: 05-13-2013, 08:08 AM
  6. How to arrange in ascending order all subtotals
    By faisal123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-17-2013, 06:12 AM
  7. Arrange Data on Pivot table in Ascending order
    By Excel Dumbo in forum Excel General
    Replies: 1
    Last Post: 07-19-2012, 08:53 PM

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