Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect cell format
how can I keep the cell format the same (protected) when I copy and paste
another cell into it? ie. Cell A1 from Sheet 1 is protected with center justified-text along with cell color RED. This sheet is protected and user is not allowed to edit the format. Cell B1 from Sheet 2 is left justifed with no cell color. If I copy B1 Sheet2, and paste it into A1 Sheet1 (Format protected), the red cell is now not colored RED, and the text is now Left-Justified. How do I keep the cell red and centered justified. I mean....shouldn't it keep it's format since it's protected from changing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect cell format
If you're doing the work, you can Copy|paste special|values.
Or even copy from the formula bar and paste into the formula bar (selecting the appropriate cells first). If you're not doing the work, then you could either give the user a macro to do the copy|paste special|values (and lock cells and protect sheets) -- or you could try to teach them to use paste special values. johncaleb wrote: how can I keep the cell format the same (protected) when I copy and paste another cell into it? ie. Cell A1 from Sheet 1 is protected with center justified-text along with cell color RED. This sheet is protected and user is not allowed to edit the format. Cell B1 from Sheet 2 is left justifed with no cell color. If I copy B1 Sheet2, and paste it into A1 Sheet1 (Format protected), the red cell is now not colored RED, and the text is now Left-Justified. How do I keep the cell red and centered justified. I mean....shouldn't it keep it's format since it's protected from changing? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I protect cell numbering format ($) but allow editing? | Excel Discussion (Misc queries) | |||
How to protect a cell with conditional format? | Excel Worksheet Functions | |||
In excel how do I protect the format of a cell but let the user c. | Excel Discussion (Misc queries) | |||
How can I protect only format of the cell ? | Excel Discussion (Misc queries) | |||
Protect Format OF Worksheet | Excel Worksheet Functions |