Discover new tools to get things done.
This tool lets you copy and paste multiple selected ranges simultaneously.
Excel does not easily support copying non-contiguous ranges; when you try, you may receive an error ("This action won't work on multiple selections"), or Excel might only copy contiguous cells while ignoring the gaps.
With this tool, you can copy all your selected ranges at once, making it simple to work with non-contiguous data.
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Tip:Alt+P for the previous tool.