Select cell ranges that are not continuous

Drag over the first part of the range you want to select.  Then press and hold the ctrl key on your keyboard and keep it pressed whilst you select the other parts of the range you want to highlight.  You will notice that whilst the ctrl key is selected you are able to select any cells within the spreadsheet even if they are not next to each other.

Leave a Reply