print friendly version

Questions and answers

How do I select separate ranges of data in Excel?

Select the first 'block' of data, then hold the [Ctrl] key down and select the next 'block' of data with the mouse. Continue holding [Ctrl] and highlight further 'blocks' of data.

Help us to improve this answer

Please suggest an improvement
(login needed, link opens in new window)

Your views are welcome and will help other readers of this page.


This is question number 258, which appears in the following categories:

Created by Jason Bailey on 27 July 2001 and last updated by Paul Ryan on 6 September 2016