Home |
Search |
Today's Posts |
#1
|
|||
|
|||
import from excel
I have an spreadsheet formatted in Excel. When copying and special rtf
pasting in a Word template, the formatting changes (not lost). For example, the row heights, cell padding etc. How can I import and retain the exect formatting ? |
#2
|
|||
|
|||
Hi Prakash
Try pasting into Word as a Picture (Enhanced Metafile), rather than RTF. You can still link to the Excel file if you need to. Or, in Excel, select the range, hold down Shift, and then do Edit Copy Picture. Choose "As shown when printed" and click OK. And now paste into Word. Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word "Prakash Mistry" Prakash wrote in message ... I have an spreadsheet formatted in Excel. When copying and special rtf pasting in a Word template, the formatting changes (not lost). For example, the row heights, cell padding etc. How can I import and retain the exect formatting ? |
#3
|
|||
|
|||
Shauna:
There are times I can paste in Excel and it "morphs" into a Word table with all the formatting (font, merges, etc.) intact. Other times it goes totally screwball! Is there any rhyme or reason as to why it does one time but not another? Ed "Shauna Kelly" wrote in message ... Hi Prakash Try pasting into Word as a Picture (Enhanced Metafile), rather than RTF. You can still link to the Excel file if you need to. Or, in Excel, select the range, hold down Shift, and then do Edit Copy Picture. Choose "As shown when printed" and click OK. And now paste into Word. Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word "Prakash Mistry" Prakash wrote in message ... I have an spreadsheet formatted in Excel. When copying and special rtf pasting in a Word template, the formatting changes (not lost). For example, the row heights, cell padding etc. How can I import and retain the exect formatting ? |
#4
|
|||
|
|||
Hi Ed
I've never seen this happen. But I almost always paste from Excel with Edit Paste Special either as a picture or as unformatted text, depending on the need of the day. Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word "Ed" wrote in message ... Shauna: There are times I can paste in Excel and it "morphs" into a Word table with all the formatting (font, merges, etc.) intact. Other times it goes totally screwball! Is there any rhyme or reason as to why it does one time but not another? Ed "Shauna Kelly" wrote in message ... Hi Prakash Try pasting into Word as a Picture (Enhanced Metafile), rather than RTF. You can still link to the Excel file if you need to. Or, in Excel, select the range, hold down Shift, and then do Edit Copy Picture. Choose "As shown when printed" and click OK. And now paste into Word. Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word "Prakash Mistry" Prakash wrote in message ... I have an spreadsheet formatted in Excel. When copying and special rtf pasting in a Word template, the formatting changes (not lost). For example, the row heights, cell padding etc. How can I import and retain the exect formatting ? |
#5
|
|||
|
|||
Thanks for the input, Shauna. I can't figure out what's happening. I've
got Word / Excel 2000: I use Ctrl+C in Excel - I use EditPaste Special (RTF), and I get a table with any merged cells split; I put Selection.PasteSpecial wdPasteRTF in a macro, and I get a table with all merged cells intact. If I choose Metafile, I get a nice looking graphic of my table that I can scale to size, but I can't edit it like a table. I can edit it, though, if I want to ungroup all the lines and boxes and dig down to the one I want. The Copy as Picture in Excel is okay, and gives me a nice clean graphic, but still uneditable in Word. So I guess there's really no good way to put a large Excel table into Word as an editable, scaleable table. Oh, well. Ed "Shauna Kelly" wrote in message ... Hi Ed I've never seen this happen. But I almost always paste from Excel with Edit Paste Special either as a picture or as unformatted text, depending on the need of the day. Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word "Ed" wrote in message ... Shauna: There are times I can paste in Excel and it "morphs" into a Word table with all the formatting (font, merges, etc.) intact. Other times it goes totally screwball! Is there any rhyme or reason as to why it does one time but not another? Ed "Shauna Kelly" wrote in message ... Hi Prakash Try pasting into Word as a Picture (Enhanced Metafile), rather than RTF. You can still link to the Excel file if you need to. Or, in Excel, select the range, hold down Shift, and then do Edit Copy Picture. Choose "As shown when printed" and click OK. And now paste into Word. Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word "Prakash Mistry" Prakash wrote in message ... I have an spreadsheet formatted in Excel. When copying and special rtf pasting in a Word template, the formatting changes (not lost). For example, the row heights, cell padding etc. How can I import and retain the exect formatting ? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Fields from Excel to Word | Microsoft Word Help | |||
Import Excel sheet | Page Layout | |||
Import converter Excel to Word for labels mailmerge | Microsoft Word Help | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
Can I import a Word Doc.file into Microsoft Excel? | New Users |