Ask Your Question

how can Calc be set to highlight the row of the active cell

asked 2017-11-12 20:04:54 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have many-columned worksheets that would be easier to read and update if the row of the active cell were high lighted from border to border. I understand how to highlight the row by clicking on the left most border (row number), but it doesn't stay highlighted when I move the cursor to a cell on the line.

Am using Win7 Pro and LInux Mint 17.3.

According to the document foundation this issue apparently has not been solved (tried the macros and could not get them to work).

edit retag flag offensive close merge delete


Please state your OS so others can help you better. You can check your 'Options' under the Tools-menu. In the Calc -> General settings you can activate 'Highlight selection in column/row headers' this will indicate the cell position in the row and column indicator line.

Henk C. Meerhof gravatar imageHenk C. Meerhof ( 2017-11-13 19:48:54 +0200 )edit

I am using Win7 and LO Version: - I can't replicate your problem. When I select a complete row or column, this will stay in it's selected color while I move the mouse over the cells. Highlighting first disappears when selecting a cell in that row/column.

Henk C. Meerhof gravatar imageHenk C. Meerhof ( 2017-11-13 19:49:45 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-11-13 22:33:21 +0200

Jim K gravatar image

updated 2017-11-13 22:35:41 +0200

Instead of highlighting the row, create a cell style that has a background color.

Then go to Format -> Conditional Formatting. Input a formula for alternate rows to use the style, as explained at

edit flag offensive delete link more

answered 2017-11-14 01:18:11 +0200

Lupp gravatar image

updated 2017-11-14 02:08:18 +0200

It's a questionable approach to use "macros" for the purpose. How to do it and how to call the macro with the help of a listener is demonstrated here:
The solution is only applicable to sheets that do not use hard (direct) cell formatting. To preserve directly assigned cell attributes would require to apply a conditional format to overlay the highlighting. There are complications and disadvantages, however, again.

I added a demo how to use CF for the purpose to the above linked thread. Not actually recommended!

edit flag offensive delete link more


The demo is pretty cool, and I'll upvote because it directly answers the question. But yeah, probably not good for common use.

Jim K gravatar imageJim K ( 2017-11-14 16:35:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-12 20:04:54 +0200

Seen: 633 times

Last updated: Nov 14 '17