Sorting Data question

  • Thread starter Thread starter RPIJG
  • Start date Start date
R

RPIJG

I am trying to get data to sort so that when I sort by a column, i
actually moves all the data in the row along with it as though tha
data was anchored to it.

Example

Tom 3 D 66 JH L
Bob 4 F 56 GH N

If I sort by column D I want all of Bob's information to move on top s
it looks like:

Bob 4 F 56 GH N
Tom 3 D 66 JH L

I can only get it to sort the column, but then I've basically assigne
the wrong values (example):

Tom 3 D 56 JH L
Bob 4 F 66 GH N

Is there anyway to do this
 
You need to highlight (Select) the entire range you want to sort (A1:G
in your example), then click Data>Sort from the main menu to call u
the Sort dialog box. Select your desired column to use for the sor
(Column D in your example), pick Ascending or Descending, and clic
either Header row or No header row. Click OK to do the sort.

TIP: always SAVE your data BEFORE you do a sort, just in case th
results are NOT what you planned!

Good Luck

Bruc
 
Back
Top