What it does
Uses picker prompt to provide special copy options for user to select from (copy formulas, copy sum of selected cells, copy values of selected cells separated by delimiter, copy workbook, etc.).  See the full list of options below in the Instructions section.

When to use it
When working with data or files, and you want to copy something other than cells (formulas, formats, raw text, etc.), this is an easy way to quickly apply copy actions.

Why to use it
It’s easier and quicker than using the mouse, combining several clicks into one step, providing shortcuts to tougher-to-find menu options, and providing options that extend the native capabilities of Excel.

Default shortcut
Ctrl+Shift+C

Other Details

• Category: Copy and Paste / Copy
• Difficulty: 2/5
• Usage/frequency: 5/5
• Automation factor: 3/5 (estimated 3 seconds saved each time used)
• Type: Shortcut
• Date added: 1/15/2018
• Tags: copy, picker

Related Macros
[F] Copy Formula
[S] Copy Select Sum
[V] Copy Values To Formula
[D] Copy Values To Delimitted Text
[R] Copy Range Address
[A] Set Format Range
[E] Set Copy Sheets
[B] Bulk Copy Paste
[U] Duplicate Sheets
[W] Copy Active Workbook To Clipboard
[Q] Copy File Shortcut To Clipboard

Note: most of the related filter macros above will be covered in the instructions below.  The picker option code is displayed in the [brackets].

Other Articles
None

None

Prerequisites
Most options: select the cell(s) to copy from
Options T, W, and Q: Select the workbook to copy the file path, file or file shortcut to the clipboard

Instructions
With cells/workbook selected per the prerequisites above, run the Copy Special Picker macro.  It will present several helpful actions to run for copying data other than just cells.  For the action you run most often, you can set your default so you don’t have to enter it (just launch the picker and press Enter).  Note that the default is highlighted when the picker is launched, so to change the action code, there is no need to press the backspace first.  Further instructions for the individual action codes are described below.

• [F] This will copy the formula of the top-left selected cell to the clipboard.  Note that this is hard-coded and will be pasted as such – without any relative references changing.  This is useful for documenting a formula when you change it or paste values over formulas.
• [P] This will copy the formats of the selected cell(s), mimicking the format painter.  Note that this will apply the formats to the next range you select with the mouse or keyboard.
• [S] This will copy the values of all selected cells to the clipboard in a raw format.  If any of the cells has a non-numeric value, all cell values will be copied to a string, with each value separated by a delimiter.  You are prompted for which character delimiter to use – the default is the pipe “|” character.  This default can be reset to your preference.
• [M] Similar to option [S] above, this will copy the values of all selected cells to the clipboard, but in a currency format ($ sign, comma-separated thousands, and two decimals).  If any of the cells has a non-numeric value, a delimited string is copied to the clipboard, similar to option [S] above.
• [V] This will copy the values of the selected cells to a formula starting with an = sign and separated by the + sign.  Example: selecting cells with values of 123, 456, and 789 would result in a string of “=123+456+789” copied to the clipboard.  If any of the cell values is non-numeric, the values are wrapped in quotes, concatenated, and separated by a comma.
• [D] This will copy the values of all selected cells to a string, concatenated by the specified character, then copy to the clipboard.  To specify a delimiter, add it to the D at the prompt (for example, enter “D|” to separate all selected cell values by a “|” character and copy to the clipboard.
• [N] This will copy the range name of the current selection to the clipboard, if there is a range name applied.
• [R] This will copy the range address of the selected cells to the clipboard.  To also copy the sheet name, add an S (enter “RS”).  To copy the workbook and sheet, add a B (enter “RB”).
• [T] This will copy the file path of the active workbook to the clipboard.
• [I] This will copy the cell addresses of all selected cells individually, separated by a line break, to the clipboard.
• [H] This will copy the name of the active sheet to the clipboard.
• [A] This acts like the format painter, setting a cell range to be used to paste formats to multiple ranges.  Run this option, then use the Apply Format Range macro (or the Paste Special Picker macro, option [P].  You can apply the formats over and over again until the range is reset with this macro/option.
• [E] This will set a sheet to copy multiple times.  Run the Paste Special Picker macro, option [Z], to paste the sheet.  You can paste the same sheet over and over again until the sheet is reset with this macro/option.
• [B] This will run the Bulk Copy Paste macro.  See the [support page] for that macro for specific instructions.
• [U] This will duplicate the selected sheet(s) (copy and paste in one step).  Optionally, you can add a space and enter the name of the pasted sheet, which will apply to the first selected sheet to be copied.
• [W] This will save the active workbook and copy it to the clipboard, so it can be pasted to an email, another folder, website, etc.
• [Q] Similar to option [W], this will copy a shortcut link to the clipboard, pointing to the active workbook. 

Like most of the picker macros, you can set the default option to apply so you don’t even have to enter the letter/number – just the Enter key.  Just enter your preferred default letter(s), then click the default checkbox, and those letter(s) becomes the new default.