Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste text from webpages into cells and keep formats
Subject basically says it all... I always get new formats (frames,
alignment etc.). Is there a way for the whole Excel sheet to only paste the contents and not having to go via the right click menu + dialog to paste only the contents? I'm collecting data for an application like addresses, emails, URLs and it's pretty annoying that the formats are changed every time when pasting. Maybe there's an option that I can't find?? TIA Karsten |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste text from webpages into cells and keep formats
it's pretty annoying that the formats are changed every time when pasting.
Agreed but I don't a way to get Excel to default to destination format. I recorded a macro while pasting and switching to destination format and I got this, which seems to do the job: Sub Macro1() ActiveSheet.PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:= _ False, NoHTMLFormatting:=True End Sub -- Jim "Karsten Wutzke" wrote in message ... | Subject basically says it all... I always get new formats (frames, | alignment etc.). | | Is there a way for the whole Excel sheet to only paste the contents | and not having to go via the right click menu + dialog to paste only | the contents? | | I'm collecting data for an application like addresses, emails, URLs | and it's pretty annoying that the formats are changed every time when | pasting. | | Maybe there's an option that I can't find?? | | TIA | Karsten |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
paste conditional formats as formats | Excel Discussion (Misc queries) | |||
Cut/paste cells based on text color or certain characters | Excel Discussion (Misc queries) | |||
how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
How do I edit, copy and paste text in excel cells? | New Users to Excel |