Paste special

G

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.
~~~~~~~~~~~~~~~~~~~~~~~~
 
A

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.
~~~~~~~~~~~~~~~~~~~~~~~~
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Special 5
Customise Date Format 5
Printing of Borders 0
Excel 2000 to Excel 2007 1
Excel 2000 and Vista 12
Comments 2
Formatting Cells 4
Macros missings 3

Top