In spreadsheet applications like Excel, selecting non-contiguous (non-adjacent) cells requires holding the Ctrl key while clicking on individual cells. This allows users to build custom selections across different areas of the worksheet. Shift (A) is used for selecting contiguous ranges, ALT (B) has various functions but not for selection, and Tab (C) is for navigation between cells.