Re: EXCEL- resorting rows so they each relate to original rows


  1. Lisa288
    Posts : 24
    64
       New #1

    Re: EXCEL- resorting rows so they each relate to original rows


    Hi,

    I couldn't find an answer in the Forums for this in the past half hour of looking through them- there are so many, and I need an answer sooner than in the 4 or 5 days it will take me to get through them in HOPES of finding my answer. Sorry. So could someone who knows Excel in Windows 7 help me?

    I uploaded a bunch of keyword searches. Came up with 4 columns and anywhere from 100- 400 rows. I need to sort these in different ways. By Keyword so the spreadsheet is by alpha, then by Demand with highest at top/lowest at top, by Supply highest at top/lowest at top, and by Profitability highest/lowest. I know I can't do all at once, I am referring to different sorting methods.

    Example: (you have to imagine 4 columns, and the numbers going under each column- when I saw the preview it bunched the numbers together and I can't seem to put them where they belong, but the first # goes under the second col (B), second # goes under "C", third # goes under "D" column:

    COLUMNS:

    A-----------------------------B-----------C-------------D

    KEYWORD DEMAND SUPPLY PROFITABILITY
    breathing exercises 7995 5306 1507
    celebrations 8523 142301 60
    cervical 10235 58395 175
    chakra 28455 43099 660

    My problem has been that in reading the instructions I don't understand how to do this (perhaps I'm just dumb!) so that each word will still have the "right" numbers across each row...e.g. say I want to move the rows so LOWEST profitability shows at top. In example, that would be the word "celebrations." I need to have all rows retain the numbers that refer to celebrations- not just have the numbers under "Profitability" change because then, they would not match up to the keyword. I need the new first row to read: celebrations 8523 142301 60 and all other rows to line up so the numbers still match up to the words like that.

    In other words I need all columns sorted so lowest Profitability (60) is at top of page, but the ROW remains reading as it does now...and my 'sort' continues down that column with next-lowest profitabilty, and next... but again, I need all rows to remain the same across as they appear now. (I can't have 'chakra show up with Profitability of 60.)

    I hope I'm explaining this right. In reading how to sort, I can only seem to figure out how to sort ONE column at a time, when I need all ROWS to change right along with each column, so that the current, proper numbers relate to proper words as they appear now. I'm guessing this is a very basic question for anyone who uses Excel.

    Any help would be very much appreciated!

    Thanks very much,
    Lisa
      My Computer
    Quote Quote

  3. kegobeer
    Posts : 2,913
    Windows 7 Ultimate x64 SP1
       New #2

    When you sort in Excel, you select all of the rows and columns of the data to be sorted. When you apply a sort to one (or many) columns, all of the data on each row is kept complete and moved up or down.

    Is that what you needed to hear?
      My Computer
    Quote Quote

  4. Lisa288
    Posts : 24
    64
    Thread Starter
       New #3

    Yes, it's what I mean (thanks for the quick reply)...how do I do this? Do I highlight all rows and columns I want to sort? How do I then sort by one column if I've done this? Could you just tell me the steps involved, please?

    Thanks so much!
    Lisa
      My Computer
    Quote Quote

  6. kegobeer
    Posts : 2,913
    Windows 7 Ultimate x64 SP1
       New #4

    Yes, you highlight the rows and columns of your data, then sort by the column you want.

    You should check out the following links.

    Sort data in a range or table - Excel - Office.com
    Excel Sorting Data Basics
      My Computer
    Quote Quote

  7. Lisa288
    Posts : 24
    64
    Thread Starter
       New #5

    Thanks for the additional info...I'm reading about it now...just wanted to let you know I got your message
      My Computer
    Quote Quote

  8. Lisa288
    Posts : 24
    64
    Thread Starter
       New #6

    WORKED! Thank you so very much!

    Lisa
      My Computer
    Quote Quote

  10. kegobeer
    Posts : 2,913
    Windows 7 Ultimate x64 SP1
       New #7

    You're welcome.
      My Computer
    Quote Quote

  11. Lisa288
    Posts : 24
    64
    Thread Starter
       New #8

    I just never found the right area to explain how to do it in my own searching. This will help me TREMENDOUSLY because I'm building a website and I'll be needing to do these sorts on hundreds of Excel files!

    :) Have a great night, and again, thanks so much for such a QUICK reply!

    Lisa
      My Computer
    Quote Quote

 

  Related Discussions
I am working on a big excel sheet, with around 2000 vertical rows. Until recently there was no problem scrolling up and down to check/add content 'down under', towards the end of my workspace. But now, if I use the SCROLL BAR button, it jumps from let's say row 100 directly to row 100.000+ or so....
Too Many Rows (MS WORKS)
in Microsoft Office

When I copy 6 or 7 rows of data and attempt to paste it into a Works spreadsheet I get this error message. "There are too many rows. Works does not allow more than 16,384 rows." It will only put in about 4 rows of data. How can I get rid of the error message?
Hi all, Well, I've done it somehow. I have a spreadsheet in Excel 2007 in which I keep all our accounts. Since I had to come up with a Minimum Required Distribution this year, I tried tacking it onto later columns in this sheet. Worked great, once. Then the formula I used: ...
The standard 7-row WMC EPG on my Windows 7 64-bit system wastes a lot of screen space I want to increase number of rows to 9, 10 or 11 I've seen instructions for doing this on a couple of sites, but the reader comments indicate a high failure rate Can anyone point me to reliable instructions...
I have attached two images of an Excel worksheet. I have gone to the trouble of taking multiple sets of three columns of associated data, that is data of x, y, z where y and z are associated with x. In building a new table with six sets of data, I put x1, x2, ..., x6 in a single column, and then...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 14:49.
Find Us