Copy/Past from Word-spreadsheet format alignment disregarded

J

Janet A. Thompson

I copy cell data from Word and used the clipboard to paste into Excel cells.
I had preformatted the spreadsheet with the Format, Alignment, wrap text.
But when I pasted into each cell from the clipboard, it came in unwrapped.

What is the best practice for doing this efficiently. I have lots to
copypaste!
 
J

Janet A. Thompson

How?
As I paste the info into the cell, I use the smart tag to format like
destination . I do this sequence each time I paste a cell. This is
time-consuming. Is there any way better?
 
D

Dave Peterson

If you're pasting into a single cell, maybe you could paste into the formula
bar.
 

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

Top