How do I highlight all cells in an Excel row?
I'm using Excel 2010 on Windows.
The shortcut to select a complete row is ShiftSpace.
Similarly, in order to select a complete column, press CtrlSpace.
|show 1 more comment|
Similarly, to select only the contiguous cells with data in them, i.e. not every cell on the current sheet...
CtrlShift+right arrow will select the row
CtrlShift+down arrow will select the column
Incidentally, choose up, down, left, or right depending on where you are on the sheet. The keyboard combinations above will select in the direction you hit from the selected cell as the starting point.