Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Paste Special Function | Excel Discussion (Misc queries) | |||
How does the PASTE.SPECIAL function work? | Excel Discussion (Misc queries) |