simple question, hopefully a simple answer!

[John Proud]

What about selecting the cells, ctrl+c then goto destination and doing a
ctrl+v?

Cheers

John

 

[C Petrin]

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

 

[Ron de Bruin]

Paste Special Values is the only way Matt

 

[John Proud]

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

 

[Matt B]

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

 

[Matt B]

Thats what Im doing at the moment and when I do this the format of the cells
im copying is also pasted (which I dont want)