Select the whole column SELECTION CTRL + SPACE Select the whole row SELECTION SHIFT + SPACE Select table SELECTION SHIFT + CTRL + SPACE bar Save SELECTION CTRL + s Select visible cells only SELECTION ALT + ; Select entire region SELECTION CTRL + A Select range from start cell to far left SELECTION SHIFT + Home Select range from start cell to end in direction of arrow SELECTION SHIFT + End + arrow Select a continuous range of data (e.g. pivot), no matter where your cursor is. SELECTION CTRL + * Select blank cells SELECTION F5 + ALT + S + K + ENTER Select all cells with comments SELECTION CTRL + SHIFT + O Select all cells that are directly or indirectly referred to by formulas in the selection SELECTION CTRL + SHIFT + { Select all cells with formulas that refer directly or indirectly to the active cell SELECTION CTRL + SHIFT + } Selects all the way to a1 from cursor position SELECTION CTRL + SHIFT + HOME ...