We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc - Change colors of row and column headers [closed]

asked 2016-08-27 17:52:36 +0200

miketurn gravatar image

updated 2021-06-11 08:22:00 +0200

Alex Kemp gravatar image

Hello Everyone,

I was wondering if it is possible to change the colors of the row and column headers? Currently...

Unselected row and column header backgrounds are light grey with black text.

Selected row and column header backgrounds are blue with white text.

Is it possible to change the color of unselected background and text / selected background and text? This might be a nice option to add if there isn't one already created.

Thank You

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-16 14:36:13.163497

2 Answers

Sort by » oldest newest most voted

answered 2016-08-27 18:24:05 +0200

mark_t gravatar image

On windows this is selected by the operating system display theme, I think its the same on other OS types.

edit flag offensive delete link more


I am speaking of the Row and Column headers within Calc. Row Header 12345 etc. and Columns Header ABCDEF etc. Is this what you are referring to? I wouldn't think that would have anything to do with Windows OS, I will check it out. Thank You for your response

miketurn gravatar imagemiketurn ( 2016-08-27 19:07:30 +0200 )edit

Yes thats the ones I'm referring to.

mark_t gravatar imagemark_t ( 2016-08-27 20:03:06 +0200 )edit

Thank You for your response

miketurn gravatar imagemiketurn ( 2016-12-10 03:58:28 +0200 )edit

answered 2016-12-10 03:57:19 +0200

miketurn gravatar image

I have messed around with changing my Windows themes and it does change the color of these headers. If there is no other way to change this though, it doesn't make any sense, that I would have to change my Windows theme to accomplish this. With the color being a bright vivid blue it looks nice but there is a reason why Excel just uses a no color outline and a bolding of the row # and the column letter, because if you have a spreadsheet that contains colored fills, it makes the bright blue column headers appear to be a part of the color fills. This should be something that can be customized with an option to have no color highlight of the headers. Hopefully others agree.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-08-27 17:52:36 +0200

Seen: 1,190 times

Last updated: Dec 10 '16