sort a group
 

I am having problems sorting columns. I want to arrange my columns by
birthday here is an example of my speadsheet.

Employee Name Birthday Employee Name Birthday
Joe 01-18 Doe 02-20

It will not sort the whole worksheet correctly

sort a group
 

Is that the actual layout of your data? Across rows?

Would be much easier if the names were in one column and the dates were in an
adjacent column, say A and B

Then just select A and B and sort on B

You can sort across a row.......DataSortOptionsSort left to right


Gord Dibben MS Excel MVP


On Thu, 12 Jul 2007 09:58:05 -0700, mcblts
wrote:

I am having problems sorting columns. I want to arrange my columns by
birthday here is an example of my speadsheet.

Employee Name Birthday Employee Name Birthday
Joe 01-18 Doe 02-20

It will not sort the whole worksheet correctly

sort a group
 

Hi,

Your layout of data is incorrect.

You could infact have this way:
Employee Name Birthday
Joe 01-18
Doe 02-20

Challa Prabhu

"mcblts" wrote:

I am having problems sorting columns. I want to arrange my columns by
birthday here is an example of my speadsheet.

Employee Name Birthday Employee Name Birthday
Joe 01-18 Doe 02-20

It will not sort the whole worksheet correctly