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

Similar Threads

Copy and paste slide from one presentation to another presentation gives an error 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Copy unformatted value of cell via macro 0
VBA concatenate ranges into a new document 0
Copy/Paste (Clipboard) Issues 1
Pasting a cell into bookmarked table from excel vba 1
Linking data in MS Word into Excel 5
Pasting from the clipboard 3

Top