Exceljet

Quick, clean, and to the point

Toggle add to selection mode

Windows shortcut 
ShiftF8
Mac shortcut 
FnF8

With add to selection mode enabled, you don't need to hold down the control key to add non-adjacent cells to the current selection.

Thank you very much. The function is working fantastically. It saved me at least 3 full working days. - Rajesh
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course