Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match Destination Format
Dear,
I have a spreadsheet where I would like everything I paste into to it to match the formattting of the cells around it and not retain the formatting it had in its original location. And also it should validate the data copied to the particular cell and throw the error notes if it does not match the validation notes created. Also the data copied is replacing the drop down list mentioned in a cell. Please suggest on this. I don't want to have to select "match destination formatting" every time--I want it to default to that. Any ideas? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically match destination formatting? | Excel Discussion (Misc queries) | |||
Possible to set "match destination format" as default in paste? | Excel Discussion (Misc queries) | |||
Paste in "match destination format" macro code | Excel Discussion (Misc queries) | |||
How to set a default paste option of "Match Destination Format" | Excel Discussion (Misc queries) | |||
Make "Match Destination Format" the default | Excel Discussion (Misc queries) |