wrap text multiple column with format

  • Thread starter Thread starter Meesh
  • Start date Start date
M

Meesh

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 F5>Special>Blanks>OK

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

Hit CTRL + Enter to fill blank cells.

Copy>paste special>Values>OK.Esc


Gord Dibben MS Excel MVP
 
Back
Top