Copy and Paste Multiple Ranges at Once...

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.

Starting this tool

Additional keywords to help you find this tool:
Copy and paste multiple ranges in Excel, Copy non-contiguous ranges, Multi-range copy and paste tool, Copy and paste multiple selections, Excel multiple range copy utility, Copy non-contiguous data, Copy and paste non-contiguous cells, Multi-range data copier, Copy multiple selected ranges

Tip:Alt+P for the previous tool.