Excel 2003 default is not "Formulas" so there is no difference between versions.

How about a macro assigned to a button on a Toolbar or whereever they get placed
in 2007?

Sub copy_no_change()
Dim rng1 As Range
Dim rng2 As Range
Set rng1 = Selection
Set rng2 = Application.InputBox(prompt:= _
"Select Any Cell to paste to", Type:=8)
rng2.Resize(rng1.Rows.Count, rng1.Columns.Count).Formula _
= rng1.Formula
End Sub

Note: only works with contiguous copy range.


Gord Dibben MS Excel MVP

On Thu, 10 Jan 2008 13:56:02 -0800, TDS_Eric
wrote:

When you use either copy/paste or fill to copy data, the cell formatting also
gets copied. I don't mind the number formats being used, but it is extremely
annoying that other formatting such as boarders and shading gets copied too.

I have my formatting done the way I need it, but at times I need to update
the data. I do this using paste or fill. Then my formatting gets all messed
up and I spend all kinds of time fixing it.

I know I can use Paste special to just paste the data but this is a pain to
have to use every time I paste. I want Paste Special/Formulas Only to be the
Default behaviour for paste. How can I make this happen? The same for the
Fill command. I want it by default to only fill formulas, not formatting.

Is it just me, or is this different in Office 2007 than it was in Office
2003???