
22 Jul 2012  #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: ABCD 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 nextlowest 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 System Specs 
. 

22 Jul 2012  #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 System Specs 
22 Jul 2012  #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 System Specs 
. 

22 Jul 2012  #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 System Specs 
22 Jul 2012  #5 

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

My System Specs 
22 Jul 2012  #6 

WORKED! Thank you so very much!
Lisa 
My System Specs 
22 Jul 2012  #7 

You're welcome.

My System Specs 
22 Jul 2012  #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 System Specs 
Thread Tools  
Similar help and support threads  
Thread  Forum  
vertical scrolling in Excel skips my 2000 rows: jumps to 100.000+ 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.... 
Microsoft Office  
Too Many Rows (MS WORKS) 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? 
Microsoft Office  
Excel 2007 iterating formula half a million rows 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: ... 
Microsoft Office  
WMC: How do I increase # of rows in the EPG? The standard 7row WMC EPG on my Windows 7 64bit 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... 
Media Center  
Excel: Combining Rows Based on An Equal Value in One Column 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... 
Microsoft Office 
Our Sites 
Site Links 
About Us 
Find 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 15:00. 
