Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I highlight cells as they are copied?
I would like to copy data from one worksheet to another but every time I do
that, I need the data highlighted to show it has been copied. Is there a way of doing this automatically? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I highlight cells as they are copied?
The easiest way I can think of to do that is to background-color ALL of the
cells on the sheet you are copying FROM first, the use Copy PasteSpecial All, instead of just Copy and Paste.........this will bring the background color forward as well as the value. This would signify that the cell had been copied to......you could even use different background colors for different sheets copied FROM to provide a key as to where the data came from. Vaya con Dios, Chuck, CABGx3 "redredrobin" wrote: I would like to copy data from one worksheet to another but every time I do that, I need the data highlighted to show it has been copied. Is there a way of doing this automatically? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert copied cells | Excel Worksheet Functions | |||
Insert Copied Cells? | Excel Discussion (Misc queries) | |||
insert copied cells | Excel Discussion (Misc queries) | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |