Copy and Paste Multiple Ranges at Once...

ASAP Utilities › Range › 17. 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

Click ASAP Utilities › Range › 17. Copy and Paste Multiple Ranges at Once...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Range › 17 Copy and Paste Multiple Ranges at Once...

Additional keywords for 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

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Cut and Paste as Values (Keeping Dependents Unchanged)...

Copy and Transpose Without Changing Formula References...

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.