Microsoft Excel 2007 question: How do I associate the first entry...

How to Use Microsoft Excel for Free

What Is the File Extension Xlt?

Difference Between the Versions of MS Office 2007

Excel Workbook Definition

What Is Excel?

How to Buy Microsoft Excel Software

How to Learn Excel 2007

Microsoft Excel Parts & Definitions

Search for Answers

Browse Members

The last question was answered in just

minutes Let our thousands of members help!

Microsoft Excel

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? By Godless Heathen Asked Apr 9 2009 8:45AM	15 Pts Rate Question

Answer Question

Help someone!
Get the latest questions in Microsoft Excel

Welcome to Answerbag, a community of people sharing what they know.
Sign up now to ask a question or help someone else by giving an answer!

Sort answers by: Rating | Date Arrow Down

Answer 1 out of 2

by Cyanotic Wasp on Apr 9, 2009 at 3:43 pm Permalink

Manually, when you select the range of data to be sorted. If you select even one cell in a contiguous range, then choose Data / Sort, Excel will attempt to identify the bounds of the range that it thinks belongs together. It doesn't work so well if you have blank rows and columns, but it gives it the old college try.

Pts

Rate Answer

Comments (be the first to comment)

Answer 2 out of 2

by Tinkerbell on Apr 9, 2009 at 8:49 am Permalink

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.

Pts

Rate Answer

Comments

Godless Heathen Apr, 09 2009 at 08:58 AM

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.

Godless Heathen Apr, 09 2009 at 08:59 AM

Tina, is that you?

Tinkerbell Apr, 09 2009 at 09:04 AM

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.

Add an Answer

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?

How to write a good answer

Your answer:

Display answer in fixed-width font (good for tables or text diagrams)

Answers must adhere to our Terms of Use

To create links, just type the address with no HTML code. Use the Preview button at the bottom to verify.

You can edit your answer at any time.

Send me new answers to this question
Send me new questions in Microsoft Excel

Important: Answerbag cannot guarantee the accuracy of answers submitted by members, and we recommend that you use common sense when following any advice found here. Read full disclaimer.

Have a question? Ask it! Know an answer? Share it!

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?

Site Links:

Additional Links:

Partner Sites: