9
2
I need to work with large table. Something like in this illustation image will be helpfull for better orientation:
Is there some settings which makes this possible?
user3123061
Posted 2015-04-09T08:46:35.187
Reputation: 213
How to highlight whole row and column under cursor in OpenOffice Calc?
Answers
10
Not exactly as requested, but SHIFT+SPACE / CTRL+SHIFT+SPACE selects current row / column respectively (at least in LibreOffice Calc - i didn't test it with OpenOffice!). To unselect, just move the selection using the cursor keys.
tohuwawohu
Posted 2015-04-09T08:46:35.187
Reputation: 8 627
1Yes this works in OpenOffice too. Good tip, thanks. – user3123061 – 2015-04-11T12:50:26.187
Clarification: Shift-Space selects the entire Row. Ctrl-Shift-Space selects the entire Column. An effect of selecting a row/column is that that row/column is also highlighted. Cannot just highlight both row and column as the pic indicates, because it is actually a selection, which would instead select the entire table. However, one could format cells with a background color. First select a row or column, then fill with background color, then repeat with the other. More labor intensive, but also pervasive. – SherylHohman – 2019-12-10T23:14:31.820
1As of 4th of Febuary, 2020 in LibreOffice 6.3.4.2, Ctrl-Shift-Space selects all cells in the sheet. Ctrl-Space selects the entire column and Shift-Space selects the entire row. – 0x4kgi – 2020-02-04T06:39:11.540
1
Currently, it is not implemented. There's a feature request for this for LibreOffice at https://bugs.documentfoundation.org/show_bug.cgi?id=33201
– nachtigall – 2017-03-01T04:58:54.957