| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maintain cell formatting in target cell when using Paste
Is there an Excel setting to prevent copied cells from changing the cell
format in the target cells? or in other words... is there a setting to always treat Paste as if Paste Special | values had been used? .. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maintain cell formatting in target cell when using Paste
You can enable the "show paste options button" in ToolsOptionsEdit.
After pasting, click on the button and check the option "match destination formatting" Gord Dibben MS Excel MVP On Mon, 26 Feb 2007 15:07:00 -0800, bbotzler wrote: Is there an Excel setting to prevent copied cells from changing the cell format in the target cells? or in other words... is there a setting to always treat Paste as if Paste Special | values had been used? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In cell drop down menu with seprerate numerical target cell | Excel Discussion (Misc queries) | |||
| How do I copy and paste a worksheet and maintain all formatting? | Excel Worksheet Functions | |||
| In adjacent cell, show last date modified of target cell. | Excel Discussion (Misc queries) | |||
| maintain references when target cell moves? | Excel Discussion (Misc queries) | |||
| How to Paste Link a cell with color and maintain the color | Excel Discussion (Misc queries) | |||
Linear Mode
