simple question, hopefully a simple answer!
 

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

Cheers

John
"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

simple question, hopefully a simple answer!
 

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

simple question, hopefully a simple answer!
 

Paste Special Values is the only way Matt


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Matt B" wrote in message ...
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)


John Proud wrote in message
...
What about selecting the cells, ctrl+c then goto destination and doing a
ctrl+v?

Cheers

John
"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

simple question, hopefully a simple answer!
 

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

simple question, hopefully a simple answer!
 

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

simple question, hopefully a simple answer!
 

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)


John Proud wrote in message
...
What about selecting the cells, ctrl+c then goto destination and doing a
ctrl+v?

Cheers

John
"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