Paste special function
I have 2 worksheets: one large one with data for several employees, and a
smaller one that will be sent to individual employees. I have the smaller
worksheet formatted in an easy to read format, and will be copying data from
the larger worksheet to the smaller one.
When copying the data to the smaller worksheet, the formatting I customized
gets written over by the formatting from the larger worksheet. I know I can
use "paste special" to only copy the values and not the format. However, is
there a way to make this the "default" option for pasting so that I can use
"alt-V" instead of right clicking?
|