Tip of the Day | Thursday 19 November 2026

Discover new tools to get things done.

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

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Tip:Alt+P for the previous tool.