by Godless Heathen on April 9th, 2009

Question

Help answer this question below.

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?

Like
Report

Share:: Facebook; Twitter; Other

Answers. Showing one answer.

See all 2 answers to this question.

by Cyanotic Wasp on April 9th, 2009
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.
Comments
Add a comment...
- Like
- Report
No comments. Post one | Permalink

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

More Questions. Additional questions in this category.

What are examples of Spreadsheet application software?
by tinmanEvil on August 13th, 2011 | 1 person likes this
Is anyone on here experienced with Microsoft Excel? I need a favor, please.
by NiCkIzBacK on August 24th, 2011 | 1 person likes this
No matter what cells I select, the freeze panes option always selects the first 15 rows to freeze. How do I fix this in Excel 2010?
by Nickname on October 8th, 2011 | 1 person likes this
I need a formula in Excel that does the following.. If the value in cell A1=X, then multiply cell B1 by 5..if A1=Y, then multiply B1 by 8.
by leslie2413 on September 1st, 2011 | 2 people like this
Could someone give me a good definition of VLOOKUP in Excel?
by slimNanny on August 13th, 2011 | 1 person likes this
More Microsoft Excel See only professionally researched Microsoft Excel questions

You're reading 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?

Follow us on Facebook!

Related Ads

Professionally Researched

About Us

About Answerbag

Sitemap

Professionally Researched Questions

Legal

Privacy Policy

Terms of Use

Disclaimer

Ad Choices
Follow Us on Facebook

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!
Latest Tweet

What is a movie that was ignored you thought great? http://t.co/FsBFmVd7

Follow Answerbag on Twitter!

Answerbag

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!