Quickly select, deselect, and reverse multiple ranges in Excel

By selecting multiple ranges, work goes easy when you need to edit or delete data in these selections at the same time. You can make non-adjacent selections by holding down the Ctrl key, but it's impossible to deselect or reverse ranges quickly. However, the Select Range Helper utility of Kutools for Excel will help you work easily. With this handy tool, you can quickly apply the following operations in Excel.

Select multiple non-adjacent ranges in any worksheet easily

Deselect cells from a selected range easily

Reverse selected ranges easily

Select Kutools >> Select >> Select Range Helper. See screenshot:

Select multiple non-adjacent ranges in any worksheet easily

Choose the Union Selection option to select multiple ranges without holding down the CTRL key in the same worksheet or cross multiple worksheets.

Deselect cells from a selected range easily

Choose the Deselect Cells option to deselect some cells from the selected range.

Reverse selected ranges easily

Choose the Reverse Selection option to select a reverse range.

Demo: Quickly select, deselect, and reverse multiple ranges in Excel