keeping info together

S

sunderland27

how would i keep a row of information together. for instance if i wanted to
arrange column A alphabetically what do i need to do to have column B,C,D
arranged with that column so that all of the information is still together.
 
S

sunderland27

it only give you three columns. i have twelve columns. is there anyway to
connect the data so that it will stay with the company codes. if i sort
colomn A i want columns 1-12 to stick with it.
 
G

Gord Dibben

Make sure you pre-select all columns you want included in the Sort.

i.e. select A through L then Data>Sort.

Do not let Excel guess for you.


Gord Dibben MS Excel MVP
 
Top