| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special Question
Suppose I copy a cell and I want to paste its value and its format to another
cell, but NOT the formula. Is there a way to do this with a single copy and a single paste? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special Question
No, don't think so. Single copy, yes. But two Paste Specials; one for the
value and one for the format Regards Trevor "Dan" wrote in message ... Suppose I copy a cell and I want to paste its value and its format to another cell, but NOT the formula. Is there a way to do this with a single copy and a single paste? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special Question
OK, thanks. I do this often enough that maybe it's worth a macro.
"Trevor Shuttleworth" wrote: No, don't think so. Single copy, yes. But two Paste Specials; one for the value and one for the format Regards Trevor "Dan" wrote in message ... Suppose I copy a cell and I want to paste its value and its format to another cell, but NOT the formula. Is there a way to do this with a single copy and a single paste? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste special - formulas | Excel Worksheet Functions | |||
| Paste Special and Paste Object | Excel Discussion (Misc queries) | |||
| trying to "paste special" data; why does worksheet object appear? | Excel Discussion (Misc queries) | |||
| Paste Special | Excel Discussion (Misc queries) | |||
| i special paste | Excel Worksheet Functions | |||
Hybrid Mode
