Shift & Space Bar; to select an entire row, whilst in Excel, press shift first, and while depressed, press the space bar. This will highlight the whole row for the current cursor location. If a few cells are highlighted vertically before the keys are depressed, then all the rows highlighted in the selected range will be highlighted.
Control & Space Bar; to select an entire column, whilst in Excel, press the control key first, and while depressed, press the space bar. This will highlight the whole column for the current cursor location. If a few cells are highlighted horizontally before the keys are depressed, then all columns highlighted in the selected range will be highlighted.
Saturday, 23 January 2010
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment