Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep the cell colour fill when pasting in text?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep the cell colour fill when pasting in text?
"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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep the cell colour fill when pasting in text?
hi.
you are probably useing the paste all command. word and emails usually don't have a background color so when you paste so when you paste, you paste what's on the clipboard. to keep your color's in excel, try this... EditPasteSpecial. I think the one you want is pastespecial Values. There is an icon from the customize box you can put on your tool bars if you do this enough. unfortunately the icon is text only. you can create an icon for it if your are good with bitmaps. Regards FSt1 "sarah" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up automatic colour fill of a cell prompted by text? | Excel Discussion (Misc queries) | |||
weird no more cell fill and text colour | Excel Discussion (Misc queries) | |||
I cannot add fill colour to any cell, or use coloured text | Excel Worksheet Functions | |||
i want to Fill Color in a cell but dont want the colour to print? | Excel Discussion (Misc queries) | |||
Changing Cell Fill Colour | Excel Discussion (Misc queries) |