"Paste Special" works great, if you know about it. Unfortunately, a lot of
end-users don't. When you create, format, and protect a worksheet for use by
others, it would be nice if the formatting would remain protected from people
using "Paste".

"Peo Sjoblom" wrote:

Editpaste special there you have different options like values, formulas
and formats

--
Regards,

Peo Sjoblom

(No private emails please)


"Rock Jock" <Rock wrote in message
...
I use Excel to capture geologic data most of which is heavily formatted for
visual display and ease of understanding. When I cut and copy data in
cells,
sometimes the format is cut or copied as well. I would like Excel to have
a
layer on which the format is applied and the data residing on a different
layer. When the format layer is locked, a cut or copy or paste only
affects
data, not the format.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions