I am trying to get data to sort so that when I sort by a column, it actually moves all the data in the row along with it as though that 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 so 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 assigned 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:G2 in your example), then click Data>Sort from the main menu to call up the Sort dialog box. Select your desired column to use for the sort (Column D in your example), pick Ascending or Descending, and click 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 the results are NOT what you planned!
Good Luck
Bruce
Bruce
The older I get, the better I used to be.
USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks