ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Keyboard shortcut for Paste Special-Values (https://www.excelbanter.com/excel-worksheet-functions/195474-keyboard-shortcut-paste-special-values.html)

skoeske

Keyboard shortcut for Paste Special-Values
 
I find myself using "Paste Special - Values" a ton, a keyboard shortcut for
this function would be fabulous.

I'd also like to see a keyboard short cut for "Paste Special" in powerpoint
to drop spreadsheets and graphs in as pictures.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

M Kan

Keyboard shortcut for Paste Special-Values
 
You can use the ALT shortcuts too. Paste Special Values is ALT+E,S,V

This works for both PowerPoint and Word.

HTH
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"skoeske" wrote:

I find myself using "Paste Special - Values" a ton, a keyboard shortcut for
this function would be fabulous.

I'd also like to see a keyboard short cut for "Paste Special" in powerpoint
to drop spreadsheets and graphs in as pictures.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions


Mark[_7_]

Keyboard shortcut for Paste Special-Values
 
Not sure specifically, but in Word it is Ctrl/Alt/v.

Cheers, Mark

"skoeske" wrote in message
...
I find myself using "Paste Special - Values" a ton, a keyboard shortcut for
this function would be fabulous.

I'd also like to see a keyboard short cut for "Paste Special" in
powerpoint
to drop spreadsheets and graphs in as pictures.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions




RagDyeR

Keyboard shortcut for Paste Special-Values
 
You can add "Paste Values" to your toolbar.

Right click in the toolbar and choose "Customize".

Under the <Commands tab,
in the left window, click on "Edit".

In the right window, scroll down until you see:
"Paste Values" (clipboard icon with a 12 on it).

Then click on it and drag to your toolbar.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------



"skoeske" wrote in message
...
I find myself using "Paste Special - Values" a ton, a keyboard shortcut for
this function would be fabulous.

I'd also like to see a keyboard short cut for "Paste Special" in
powerpoint
to drop spreadsheets and graphs in as pictures.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions




Michael

Keyboard shortcut for Paste Special-Values
 
Perhaps an addition would be the ability to assign meaning to an open hot
key, example ctrl-alt-shift-v might mean past values in Excel.

The ctrl-alt-v does indeed bring up the past special dialog box in excel
2007 and is quite useful.



All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com