**Question description:**

*This user has given permission to use the problem statement for this blog.*

Hi, my problem is with excel. I ahve made a list of people with theirs jobs and salary's etc. i will need to put different parts of this in alphabetical order but i want the information that matches the persons name from different cells to all stay together when i do this alphabetical ordering? I need to group a whole row together so when i put any column into alphabetical order the whole row moves and stays together?

Solved by X. C. in 28 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
19/10/2017 - 11:56

hi hello

Excelchat Expert
19/10/2017 - 11:57

i am here to help

User
19/10/2017 - 11:57

HI, DID YOU UNDERSTAND MY PROBLME

Excelchat Expert
19/10/2017 - 11:57

you need to sort data following its row?

User
19/10/2017 - 11:57

sorry for the caps

User
19/10/2017 - 11:57

i needs rows of information to stay together when i make some coloumns alphabetical

Excelchat Expert
19/10/2017 - 11:58

you need to select all the column then use custom sort

Excelchat Expert
19/10/2017 - 11:58

like that?

Excelchat Expert
19/10/2017 - 11:59

i will make a guide for you in a picture file

User
19/10/2017 - 11:59

so on whatb you have done there. if i wanted the cell with B and the cell with 2 in to stay joined together so if i highlighted all the information and made i alphabetical them 2 rows stay together

User
19/10/2017 - 12:00

so when i make 1 column alphabetice the information in the horizontal rows stay joined together

Excelchat Expert
19/10/2017 - 12:00

yes like my sample right?

Excelchat Expert
19/10/2017 - 12:01

B is joined with 2

Excelchat Expert
19/10/2017 - 12:01

A is joined with 1

User
19/10/2017 - 12:01

YES!!

Excelchat Expert
19/10/2017 - 12:01

C is joined with 3

User
19/10/2017 - 12:01

THATS IT

Excelchat Expert
19/10/2017 - 12:01

ok,

Excelchat Expert
19/10/2017 - 12:01

i will screenshot my step

User
19/10/2017 - 12:02

so say i had someones name in 1 colum and then their salary in another column , if i made all the names alphabetical then the salary would stay with the right name

Excelchat Expert
19/10/2017 - 12:03

yes

User
19/10/2017 - 12:03

great

Excelchat Expert
19/10/2017 - 12:06

please follow

[Uploaded an Excel file]

Excelchat Expert
19/10/2017 - 12:07

please follow these and confirm if

[Uploaded an Excel file]

User
19/10/2017 - 12:07

but say letter A should be joined with number 3, would these get mixed up when i put it all in order?

Excelchat Expert
19/10/2017 - 12:08

no

Excelchat Expert
19/10/2017 - 12:08

it will not mixed up, make sure you blocked select all before sort

User
19/10/2017 - 12:08

ok great, maybe i should follow instructions and see how i go ?

Excelchat Expert
19/10/2017 - 12:08

yup

User
19/10/2017 - 12:09

thankyou, youve been more helpful than anyone else

Excelchat Expert
19/10/2017 - 12:09

have you tried it?

User
19/10/2017 - 12:10

im trying now, but it will take me abit of time

User
19/10/2017 - 12:10

so on your instructions it says to sort colum into alphabetic bevause these are the names, but when i do this , they are no longer next to their correct salary

Excelchat Expert
19/10/2017 - 12:11

you also selected the salary right?

User
19/10/2017 - 12:11

yes?

User
19/10/2017 - 12:12

but it moves them all in orders.

User
19/10/2017 - 12:12

so the names and the salarys end up next to different the wrong ones

User
19/10/2017 - 12:12

they are alphabetic but the salary that is now next to them is a different persons

Excelchat Expert
19/10/2017 - 12:12

hmm, undo

User
19/10/2017 - 12:12

ok have done

Excelchat Expert
19/10/2017 - 12:13

then do it again

Excelchat Expert
19/10/2017 - 12:13

where is your name and salary column?

User
19/10/2017 - 12:13

ok i will

Excelchat Expert
19/10/2017 - 12:13

i will make an instruction that are same with your screen

User
19/10/2017 - 12:13

my name colum is letter A column, and the salary is in the next column along (b)

Excelchat Expert
19/10/2017 - 12:14

ok

Excelchat Expert
19/10/2017 - 12:15

are the salary is caluclated using formula?

User
19/10/2017 - 12:16

no, just a writen in amount by me

User
19/10/2017 - 12:17

so, just what i writeen, how do i make jamies cell stick to £150,000, so when i put all the names in alphabetical order, the salary stays with the name

Excelchat Expert
19/10/2017 - 12:19

[Uploaded an Excel file]

Excelchat Expert
19/10/2017 - 12:19

yes, make sure you select names and salary

User
19/10/2017 - 12:21

yes!!!

User
19/10/2017 - 12:21

thats workeds

User
19/10/2017 - 12:21

worked

Excelchat Expert
19/10/2017 - 12:21

great!

Excelchat Expert
19/10/2017 - 12:21

just make sure you also selected their salary before do sorting

User
19/10/2017 - 12:22

but if i have another column next to the name, say there company name? withh these still stay next to each other ? haha sorry

User
19/10/2017 - 12:22

i have alot of info to go onto my spreadsheet

Excelchat Expert
19/10/2017 - 12:22

yes, you need to select 3rd column also

Excelchat Expert
19/10/2017 - 12:22

unselected column will not joined when sorting

Excelchat Expert
19/10/2017 - 12:23

if you have 10 columns of data, then select all the 10 columns before click sort

User
19/10/2017 - 12:23

yesss!!! it worked!!!

User
19/10/2017 - 12:23

thankyou!!

Excelchat Expert
19/10/2017 - 12:23

great!

User
19/10/2017 - 12:24

that was so helpful

User
19/10/2017 - 12:24

thankyou

Excelchat Expert
19/10/2017 - 12:24

you are welcome

User
19/10/2017 - 12:24

shall i just press end session?

Excelchat Expert
19/10/2017 - 12:24

dont forget to rate

Excelchat Expert
19/10/2017 - 12:24

yes if you dont need anything else

User
19/10/2017 - 12:24

i will rate defiantly, thankyou! :)

Excelchat Expert
19/10/2017 - 12:24

press end session will be goodbye for us

User
19/10/2017 - 12:24

goodbye for now :)

Excelchat Expert
19/10/2017 - 12:25

have a great day

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*