View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karsten Wutzke Karsten Wutzke is offline
external usenet poster
 
Posts: 1
Default 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