by Godless Heathen on April 9th, 2009

Godless Heathen

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

Answers. 2 helpful answers below.

  • by Cyanotic Wasp on April 9th, 2009

    Cyanotic Wasp

    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.

    No comments. Post one | Permalink

  • by Tinkerbell on April 9th, 2009

    Tinkerbell

    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.

Want to attach an image to your answer? Click here.

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

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

ANSWERBAG BUZZ

How to associate data in excel sorting
Microsoft excel 2007 help answers
How do i associate the first entry in a row with the rest of the row so that it will sort according to the
Objective question with options of ms excel 2007
How to associate rows with header row excel expand