How do I keep the cell colour fill when pasting in text?
Ben and Fst1
When copying data from an external source you get different choices with Paste
Special.
Unicode Text or Text from an email.
From Word you get a few other choices like paste as picture or word object, none
of them being Paste Values. That is only available within Excel.
Gord Dibben MS Excel MVP
On Mon, 21 May 2007 17:34:46 +0200, "Ben"
wrote:
"sarah" schreef in bericht
...
I need to be able to copy and paste text from e.g. word or emails, into my
spreadsheet but when I do, it changes the fill colour back to white - how
to
I lock the fill colour, or is there soemthing else I can do without
changing
the theme?
Thanks
Copy - past special - values
|)
|_)en
|