Sorry Matt

You could record a macro to do the job with a series of keypresses eg ctrl+?
after you have selected the range!

That would cut down on the activity?

Cheers

John P



"C Petrin" wrote in message
...
If your copying and pasting involves just the odd cell/range here and
there, you could create a simple macro to combine the paste special
steps, and then assign this macro to a keystroke. Something like this:

Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats



"Matt B" wrote in message
...
hi,

I have an excel sheet which has a coloured background and cell
borders. I
want to copy things into this without loosing this background colour
and
border.

I know I could just "paste special" and then "values" but I was
wondering if
there was another, less time consuming way!

TIA

Matt