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?

user3123061
  • 263
  • 2
  • 7

1 Answers1

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.

tohuwawohu
  • 10,303
  • 1
  • 35
  • 63
  • 1
    Yes this works in OpenOffice too. Good tip, thanks. – user3123061 Apr 11 '15 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 '19 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. –  Feb 04 '20 at 06:39