I need to be able to have wrapped text in multiple columns but also be able
to have formats across the way. To explain:

I need column A to be a person but that person would have info in rows
1,2,3. In other words, I want to be able to sort by the person but have
several rows for each person with formats to total across.

Thank you.

You need to enter the person's name in all blank cells of column A.

Select column A and F5SpecialBlanksOK

In active blank cell type the = sign then point or arrow up to the cell
above.

Hit CTRL + Enter to fill blank cells.

Copypaste specialValuesOK.Esc


Gord Dibben MS Excel MVP

On Thu, 10 Sep 2009 08:58:03 -0700, Meesh
wrote:

I need to be able to have wrapped text in multiple columns but also be able
to have formats across the way. To explain:

I need column A to be a person but that person would have info in rows
1,2,3. In other words, I want to be able to sort by the person but have
several rows for each person with formats to total across.

Thank you.