Prev: Pivot Table Data Source
Next: Need a shorter # of Levels
From: johncaleb on 3 May 2010 15:54
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?

From: Dave Peterson on 3 May 2010 16:28
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
 | 
Pages: 1
Prev: Pivot Table Data Source
Next: Need a shorter # of Levels