I’m doing a line by line check of some financial records and as I check each row I’m highlighting that row and then colouring it show that the data in this row has been verified. At the min I have to select the row number with the mouse to highlight the row however it would be very handy if I had a quick keyboard shortcut to just highlight that row. Is there such an shortcut in Calc?
Shift+End select in the current row, from current column to last column with data in the sheet.
Search in the inner help for: shortcut keys;spreadsheets.
Thanks mariosv that’s not quite what I was looking for as I’m often in the middle of the line of data so I needed it to select the whole line regardless of where I am on the line.
I checked out the shortcut keys:spreadsheets and the actual answer is undocumented there.
The correct key combination is:
Shift+Space
Ctrl+Shift+Space will select the whole column regardless of where your position is within the column. Again this is an undocumented shortcut.
To select the whole line irrespective of where you are on that line use:
Shift+Space
To select the whole column irrespective of where you are in that column us:
Ctrl+Shift+Space
These are both undocumented in the help shortcut keys:spreadsheets list.
Thanks for this ktz84, this led me in the right direction, but I don’t think this is quite right, or at least not in Version: 6.0.2.1 (x64). I found:
To select the whole ROW irrespective of where you are on that line use Shift+Space
To select the whole COLUMN irrespective of where you are in that column use Ctrl+Space
To select the whole SHEET irrespective of where you are in that sheet use Ctrl+Shift+Space
Any thoughts on why these are both undocumented?