| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Past from Word-spreadsheet format alignment disregarded
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! -- Janet A. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy/Past from Word-spreadsheet format alignment disregarded
Format the cells to Word Wrap.
-- Regards Dave Hawley www.ozgrid.com "Janet A. Thompson" wrote in message ... 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! -- Janet A. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy/Past from Word-spreadsheet format alignment disregarded
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? -- Janet A. "ozgrid.com" wrote: Format the cells to Word Wrap. -- Regards Dave Hawley www.ozgrid.com "Janet A. Thompson" wrote in message ... 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! -- Janet A. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy/Past from Word-spreadsheet format alignment disregarded
If you're pasting into a single cell, maybe you could paste into the formula
bar. Janet A. Thompson wrote: 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! -- Janet A. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i copy an excel spreadsheet into word document with a table | Excel Discussion (Misc queries) | |||
| copy word doc to spreadsheet so that it is over a range of cells | Excel Worksheet Functions | |||
| How do you copy and past data from one spreadsheet to another? | Excel Discussion (Misc queries) | |||
| copy & past in same format | Excel Discussion (Misc queries) | |||
| Can I insert excel spreadsheet in word and keep currency format? | Excel Discussion (Misc queries) | |||
Linear Mode
