Special Paste functions speed up your data entry by mapping paste functions of your choice to keyboard shortcuts.

Special Paste is not enabled by default. To make use of this feature, go to the Preferences dialog and click on the “Paste” tab.

Options

You can define two keyboard shortcuts of your choice and map them to one out of a list of paste functions.

Note: If you define keyboard shortcuts here, it will supercede any built-in shortcut of Excel®.

  • When I press…: A keyboard shortcut always requires the CTRL key to be pressed. You can decide if you also want to press SHIFT and/or ALT, and what letter/number key to press. You can also enter codes for special keys here.
  • … then do this: Choose one of the following self-explanatory actions:

    • Show Excel’s “Paste Special” dialog*.
    • Paste values*.
    • Transpose paste*.
    • Transpose-paste values*.
    • Send custom key sequence.

* The options marked with an asterisk are only available in English-language versions of Excel®. If you are using a non-English version of Excel, choose “Send custom key sequence” (see below).

If you want to use only one keyboard shortcut and not the two of them, just delete whatever key is entered in the “When I press…” field.

Send custom key sequence

When you press a keyboard shortcut for Special Paste, the XL Toolbox will send a key sequence to Excel that will execute the requested paste function. For example, in an English-language Excel 2007, the key sequence for “Paste values” is ALT-H-V-V.

This allows all paste actions to be undone by the user, should the need arise.

The drawback of this method is that it only works with English-language versions of Excel®, as the key sequences are specific for Excel’s user interface.

In order to enable users of international versions to use the Special Paste feature, it is possible to enter a custom key sequence into the Specal Paste preferences dialog. This sequence will be sent to the application as if they were user-entered keystrokes (the XL Toolbox uses the Application.Sendkeys method to do this).

For security reasons, the number of keys you can enter is limited.

Also, a number of special keys or key sequences are prohibited: CTRL, ESC, TAB. The purpose of these limitations is to prevent malicious software from using the XL Toolbox to remote-control your whole computer. The restrictions are set so that the key sequences can reach the Excel® menu commands for pasting, but not much else.

When running on Excel® 2003 (not 2007), the XL Toolbox will wait for the user to release the CTRL, ALT, and SHIFT keys, before sending the key sequences. If you hold any of these keys longer than five seconds, a timeout will occur, sending the keys despite CTRL, ALT, or SHIFT are pressed. In that case it is likely that the paste operation will not succeed.

Special modifier keys for the “Send custom key sequence” feature are:

Key Code
ALT % (percent)
SHIFT + (plus)
ENTER ~ (tilde)

You cannot use any of the special keys that are encoded with curly brackets ”{}” for the custom command sequence.

(For more technical information, see this page: msdn.microsoft.com/en-us/library/aa202943(office.10).aspx.)

Special Keys

It is possible to use the following special keys in the shortcut sequence to evoke the Special Paste functions:

Key Code
BACKSPACE {BACKSPACE} or {BS}
BREAK {BREAK}
CAPS LOCK {CAPSLOCK}
CLEAR {CLEAR}
DELETE or DEL {DELETE} or {DEL}
DOWN ARROW {DOWN}
END {END}
ENTER ~ (tilde)
ENTER (numeric keypad) {ENTER}
ESC {ESCAPE} or {ESC}
F1 through F15 {F1} through {F15}
HELP {HELP}
HOME {HOME}
INS {INSERT}
LEFT ARROW {LEFT}
NUM LOCK {NUMLOCK}
PAGE DOWN {PGDN}
PAGE UP {PGUP}
RETURN {RETURN}
RIGHT ARROW {RIGHT}
SCROLL LOCK {SCROLLLOCK}
TAB {TAB}
UP ARROW {UP}

Hint

Excel 2007 has a built-in keyboard shortcut that brings up the “Paste Special” dialog: Press CTRL-ALT-V. This only works when there is “pasteable” data on the clipboard.

This shortcut is not available in older versions of Excel.