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.

Data -- Sort

Hope this helps.

"sunderland27" wrote:

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.

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.

"Rajula" wrote:



Data -- Sort

Hope this helps.

"sunderland27" wrote:

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.

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

i.e. select A through L then DataSort.

Do not let Excel guess for you.


Gord Dibben MS Excel MVP

On Mon, 24 Apr 2006 07:08:02 -0700, sunderland27
wrote:

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.

"Rajula" wrote:



Data -- Sort

Hope this helps.

"sunderland27" wrote:

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.