Specifying Which Elements Users Can Select
Overview
You can let the user select only columns, rows, blocks, all cells, or any combination of these.
In addition to this setting, the operation mode of the sheet affects which elements users can select. For example, in single-selection mode, users can only select one row in the sheet at a time, similar to the behavior of a single-selection list box. For more information about operation mode, see Specifying the Operation Mode.