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?


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.

  • 1
    Yes this works in OpenOffice too. Good tip, thanks. 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. Dec 10 '19 at 23:14
  • 3
    As of 4th of Febuary, 2020 in LibreOffice, 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 '20 at 6:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.