wrap text multiple column with format

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging multiple columns into one column (dynamically) 1
sumif to work with times along a row 2
Summarise data on multiple sheets 1
Macro for multi-user reporting 2
How do I sort cell formats with data being sorted? 2
How do I auto adjust row height on merged columns w/wrapped text? 2
Excel Is this possible?? 3
sorting data from one table/range to another table/range 1

Top