How to make it easier to track across a row?

clear · February 8, 2026, 7:24pm

Selecting a row makes it easy to track across the row. Excluding that, is there a way to automatically highlight the row of the focused cell? For example all cells in the row get a temporary light-green background? or the upper and/or lower grid lines are bold? or … ?

Villeroy · February 8, 2026, 7:30pm

Tools>Options>Calc>View>Highlight Row/Column

clear · February 8, 2026, 7:46pm

Thanks, is the highlight color user configurable?

Villeroy · February 8, 2026, 7:55pm

It’s the same highlighting as for the range selections. I don’t know where that comes from.

clear · February 8, 2026, 8:23pm

cwolan · February 9, 2026, 8:21am

The highlight color appears to be the result of an operation on colors set in
Tools ⟶ Options ⟶ LibreOffice ⟶ Appearance for:
Document background and Cell focus (DOCCOLOR and CALCCELLFOCUS, respectively, in the source code).
⠀

⠀
Cf. the source code, incl. file: /core/sc/source/ui/view/gridwin.cxx and
/core/include/tools/color.hxx

clear · February 9, 2026, 6:41pm

That helped. I chose a different and darker color to make the highlighting more visible. Since that setting establishes a base color, choosing one too dark makes unreadable the row and column labels of the focus cell.

On my system I don’t have a file named *ridwin*, which makes sense as I haven’t downloaded the source. I’m not at a point where I want compile.

clear · February 20, 2026, 1:45am

@cwolan
FWIW, I’ve abandoned the approach that highlights the row and column of the active cell, Tools > Options > LibreOffice > Appearance
.
Instead,
.
In a sheet of weekly subtotals, where column A is the month, I use @anon73440385 approach, with ISEVEN($A2),
.
In sheets of general data, I highlight every 4th row. using @EarnestAl approach, IF(MOD(ROW(),4)=0) t