J
John Proud
What about selecting the cells, ctrl+c then goto destination and doing a
ctrl+v?
Cheers
John
ctrl+v?
Cheers
John
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
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
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
R
Ron de Bruin
Paste Special Values is the only way Matt
J
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
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
M
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
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
M
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)
im copying is also pasted (which I dont want)