14

I need to work with large table. Something like in this illustation image will be helpfull for better orientation:

enter image description here

Is there some settings which makes this possible?

Improve this question
2

1 Answer 1

Reset to default
13

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.

Improve this answer
3
  • 1
    Yes this works in OpenOffice too. Good tip, thanks.
    – user3123061
    Apr 11, 2015 at 12:50
  • 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
    Dec 10, 2019 at 23:14
  • 3
    As 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.
    – user1104660
    Feb 4, 2020 at 6:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .