How to sort 1 cell range keeping other range same

K

kamploops

Hello,

I have a cell range with text and 2 different cell ranges with numbers
Example..

Cell A1 has the name Jimmy
Cell B1 has the number 34
Cell C1 has the number 36

When I sort Cell A1.. I want B1 and C1 to remain linked to cell A1.

In other words, when I sort A1 TO A10.... I want the info in Cell rang
C1 to C10 to follow them. So I don't want the info in the the C-Cell
to be sorted. Just to follow the A cells after the A cells ar
sorted.

I am losing hair over this one, since I am a beginner.

Please help me,

Best wishes to all of you. I'm really glad I found this forum.

Jimm
 
P

paula

Have you tried selecting cells A1-C10, then click DATA,
SORT. Sort by Column A, then click ok.

Hope that helps!
 
Top