Microsoft Excel 2007 question: How do I associate the first entry in a row with the rest of the row so that it will sort according to the first entry and keep the data in the rest of the row with it?

I haven't used 2007 but in previous versions you would do the following

1) Select your data (include all fields you wish to sort)
2) Click the Data menu on the menu bar
3) Click Sort
4) You will be given the option to choose your sort field and direction as well as header row options.

Don't know if it is different in 2007 though.

Comments

Nope, that doesn't seem to be doing what I want...It just puts the client's name in all of the cells in the row....hmmmmmm.
- Report
by Godless Heathen on April 9th, 2009
Tina, is that you?
- Report
by Godless Heathen on April 9th, 2009
No it's not Tina I am afraid.

That's odd it always used to work like that. If all the data is selected Excel should sort all the data based upon the sort field you select keeping the row-relationships intact. Certainly does on 2003 as I just tried it.

Don't know I am afraid. Even if you click the sort button on the toolbar it should give you the option to expand the selection or just sort one column.
- Report
by Tinkerbell on April 9th, 2009

More Questions. Additional questions in this category.

Question

Microsoft Excel 2007 question: How do I associate the first entry in a row with the rest of the row so that it will sort according to the first entry and keep the data in the rest of the row with it?

Answers. Showing one answer.

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

After I enter a number in the first col. of a row, I highlight the entire row above it and drag it down to get the new data to fill in. Is there a way to have the new row fill in automatically as soon as I make the entry in the first cell of the new row?

In Excel 2007, I sorted col A and then sorted col D. The data in the other columns did not move with the sorted row. How do I undo a sort?

Entering data in excel: I want to have the cursor start in row A each time i reach the end of lenght of spreadsheet. For example; end of data is in row H. I want the cursor to automatically return to cell A afer entering data in row H and not go to row I.

In excel how do I change the size of one cell, but keep the rest of the row and column the original size?

EXCEL MACRO: I need to design a macro to read the customer codes on row1,columns(2-12) and locations on coulmn1,row(2-24) and return the values in the cells at intersection of both.The values(TEXT) of customer code and tower location is user defined data.

Professionally Researched

What are first row seats at a boxing match called?

How many seats are in Row 22 of Section 113 at the Excel Energy Center?

How do I create a new row in an Excel spreadsheet using a formula?

How do I delete a duplicate row in Excel?

How do I delete every other row of an Excel spreadsheet?

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Question

Microsoft Excel 2007 question: How do I associate the first entry in a row with the rest of the row so that it will sort according to the first entry and keep the data in the rest of the row with it?

Answers. Showing one answer.

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

Answerbag.com Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!