keyboard short cut for paste values in excel for mac

As for nomenclature, RC stands for Right Click and MK stands for Menu Key.

Below is a picture of the Menu Key in case theres confusion (its at the bottom right of the keyboard).

The Menu Key basically gives you the same menu as Right Clicking does.

So, in effect, RCMK, except one uses the mouse and the other uses the keyboard (note: some keyboards surprisingly dont have a menu key.

If your right hand is on the keyboard, simply hit the Menu Key (MK).

Typing V is faster than maneuvering and clicking the mouse since its an easy target for the left index finger (no need to move the hand across the keyboard).

So the fastest way to paste values is RC-V (or MK-V if your right hand is on the keyboard already).

Below youll see the Values (V) telling you that V is the shortcut key for pasting only Values (T is for Transpose, N is for link, etc.).

Youll also see the preview for Values in the second column reflecting what the job will look like if I choose this option.

But you unfortunately cant do the same with F (Formula), N (Link) and T( Transpose), since they all share their keyboard shortcuts with other items in the Context Menu (Format Cells, Clear Contents, Cut).

For these, you need to hit the spacebar after the letter (which you can do with your left hand) which is a small sacrifice.

You can activate that menu faster by simply typing S (since S is underlined, meaning its the shortcut key for that option).

Thus, the fastest sequence to pull up this sub-menu is RC-S (or MK-S if your right hand is already on the keyboard).

But hovering and clicking isnt the fastest method to select your option.

Thus, the fastest sequence to pull up this sub-menu is RC-S.

As with the other icons, hovering over them shows you the keyboard shortcut and a preview.

To paste values and number formatting, the fastest way is RC-S-A (A is the shortcut for Values and Number Formatting the icon with 123).

If you hover on the sub-menu, the main menu is temporarily greyed out so you can see the preview beneath it.

I suggest only memorizing your high frequency actions, adding one or two to your memory each week, using the hover technique to remind you of the shortcut key.

Well, these options are also available on the Paste Special Sub-Menu where they do not share their letters with other shortcuts.

Therefore, its possible theres a faster way to select them using the Sub-Menu than there is using the regular menu.

Thus for Transpose, you can save a keystroke by doing RC-S-T instead of RC-T-T-spacebar.

Keyboard Short Cut For Paste Values In Excel For Mac