Paste special

[Gerry Cornell]

Is there a simple keyboard shortcut to execute Paste, Special, Value.

I frequently want to convert the entry in a single or series of cells from a formula to a value. I currently use Edit, Copy followed by Edit, Paste, Special, Value. I appreciate a macro could be created but I am wondering if there is another way.



~~~~~~

TIA.

Gerry

~~~~~~~~~~~~~~~~~~~~~~~~
FCA

Stourport, Worcs, England
Enquire, plan and execute.
~~~~~~~~~~~~~~~~~~~~~~~~

 

[Andy B]

Hi

I use Paste Special Values a lot too! I have put a button on my toolbar that
does it for me. To do this go to View / Toolbars / Customize. Select 'Edit'
in the left hand list and drag Paste Values onto a toolbar.

Hope this helps.

--
Andy.


Is there a simple keyboard shortcut to execute Paste, Special, Value.

I frequently want to convert the entry in a single or series of cells from a
formula to a value. I currently use Edit, Copy followed by Edit, Paste,
Special, Value. I appreciate a macro could be created but I am wondering if
there is another way.



~~~~~~

TIA.

Gerry

~~~~~~~~~~~~~~~~~~~~~~~~
FCA

Stourport, Worcs, England
Enquire, plan and execute.
~~~~~~~~~~~~~~~~~~~~~~~~

 

[SidBord]

Hey, I do that too! I've been using my button for years.
It's a great click saver.