Excel Keyboard Command for Copy-Paste Special-Value 3

[beadedbytes]

Similar to Ctrl+C for the copy command, is there a keyboard command for Copy--Paste Special--Value?

 

[AnotherHiggins]

<Right mouse click> then <s> then <v> works. Usually when pasting values I am using my mouse to select the cell where I want to paste, so that's the shortcut I usually use.

On my keyboard, there's a key at the lower right corner between <CNTRL> and the Windows key that imitates a right mouse click - that depends on your keyboard layout though.

ALSO: <CNTRL>+" will copy the value of the cell directly above the current cell. Not terribly useful, but there it is anyway.

Maybe someone else has a better solution?

 

[xlbo]

There are seperate buttons for PS Values and PS Formats that can be dragged to the toolbar.
Other than that, I have a mini macro set up to run under Ctrl+z (rather than undo) that does a PS Values into the active cell

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[Zathras]

You can customize your Edit toolbar by adding additional icons. There is one called "Paste Values" that looks like a clipboard with the number 12 on it. I find it most helpful.

If you absolutely must have a keyboard shortcut, then I think the only way is to write your own macro.

 

[gizmo1973]

I don't have a keyboard shortcut but my tip would to create a new Custom Toolbar.
You can have the option of Paste Values on here and many others i.e. Formats as well.
I find this invaluable and always create a custom toolbar whenever I move machines

To create
Tools, Customize, Toolbars, New, "name it"
Then choose your commands that you will find most useful


Phil

"Then I’d say what’s the point of having rank if you can’t pull it?"

(DCI Jack Meadows)

 

[Zathras]

You don't need a custom toolbar. You can simply drag the icons you want to any existing toolbar.

I'm not saying don't create a custom toolbar, just that it's not necessary for adding a small number of icons to the workspace. It depends on your situation. A custom toolbar might very well be the way to go.

Click View/Toolbars/Customize... then select the Commands tab and search the categories. You will find Paste Values in the Edit Category. (Along with Paste Formatting and a few other useful items.) Click an icon and drag it to any toolbar.

 

[xlbo]

That's pretty much what I've got - I have the Paste Special, PS Values & PS Formats all next to each other - it's probably my 2nd most used area of the toolbar !!

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[gizmo1973]

Just another quick tip if you do go down the Custom Toolbar route.

Put icons that could lead to disaster near frequently used ones.
i.e. delete Rows near Paste Values
or
Email as attachment near same as when you've got a rather large workbook and hit this icon you may be waiting some time.
As Geoff says it will become a well-used area if you decide to use.


Phil

"Then I’d say what’s the point of having rank if you can’t pull it?"

(DCI Jack Meadows)

 

[gizmo1973]

Sorry that should have read

DON'T put icons that could lead to disaster near frequently used ones.



Phil

"Then I’d say what’s the point of having rank if you can’t pull it?"

(DCI Jack Meadows)

 

[xlbo]

LOL

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[AnotherHiggins]

If you're going to use pre-defined buttons for toolbars but you still want a keyboard shortcut, you can change the button type to "Image and Text" then move the ampersand (&) before any letter that you want to use as a shortcut in conjunction with <ALT>. NOTE: Make sure to chose a letter that isn't already used with alt to access menus at the top of the screen. For example, <ALT>+<v> takes you into the View menu.

For example, if you change the Name to "Paste Va&lues" (This will appear on the toolbar as "Paste Values"), you can then use <ALT>+<L> as a keyboard shortcut.

If real estate is a concern at the top of the screen, you could just name the button "&L". But as far as I know, the name has to be visible for the hot key to work.

 

[gizmo1973]

anotherhiggens

I tried the above step by step as I thought it a good idea, hence the star, but when I press <ALT>+<L> the Icon on the toolbar is highlighted (in a way) but no data is pasted in the destination cell
Any ideas?

Phil

"Then I’d say what’s the point of having rank if you can’t pull it?"

(DCI Jack Meadows)

 

[AnotherHiggins]

Sorry for the late reply, I was out of the office late last week. Are you still having problems with this?

 

[JaredTaylor74]

This may be a little late, but I thought I'd throw my 2 cents in here as well. I avoid using the mouse as much as possible, I find the keyboard mush faster. for the copy, paste special, values; all i do is hit ALT (which sends the focus to the toolbar), E, which opens the EDIT drop down, S, (which is the Paste Special), V, (which selects "Values")

in short, ALT, E, S, V.

you don't have to hold down the ALT key, just hit it, then the others. you can do this with just about anything, just have to learn/memorize the ones you want/need the most often.

hope that helps.
Jared

 

[beadedbytes]

Wow! Thanks for all the good conversation and suggestions, especially to anotherhiggins. The 'revamping' of a pre-existing toolbar button works like a charm! Thanks, JaredTaylor74 for your comments. I too am a 'keyboard baby' and will also use your recommendations!

Again, thanks all!

 

[gizmo1973]

anotherhiggeins.

Yes indeed, it still does exactly as my last post

Regards, Phil

"Then I’d say what’s the point of having rank if you can’t pull it?"

(DCI Jack Meadows)

 

[gizmo1973]

After more fiddling with this I have found then when the Icon is highlighted I then have to press enter for the Values to paste, is this how it works for you guys or is it just me?

Regards, Phil

"Then I’d say what’s the point of having rank if you can’t pull it?"

(DCI Jack Meadows)

 

[RoyVidar]

For those not having the "right click" button on the keyboard, using SHIFT+F10, performs the same, then continue with S, V and Enter (and yes, I think you need to select with Enter).

This is really a must for people working on different Laptops, since the layout of those keys don't seem very standarized;-))

Roy-Vidar