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.
1 Like
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.
1 Like
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?
1 Like