Ask Your Question

LibreOffice Calc change font of built-in row and column headers/headings [closed]

asked 2017-06-21 02:02:28 +0100

Piecevcake gravatar image

updated 2020-10-09 00:20:54 +0100

Alex Kemp gravatar image

Hi, how to make the 123, ABC appear in custom font (and font size) please? (I have changed the default font but it doesn't change the appearance of the headers) Thanks,image description

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-10-09 00:21:39.255336


upvoted so that you might post a screenshot.

librebel gravatar imagelibrebel ( 2017-06-21 08:07:05 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-06-21 09:05:54 +0100

pierre-yves samyn gravatar image


AFAIK You can not change only the font of the row and column headings: the change will also affect the other elements of the interface (menu, status bar, dialogs, sidebar...). To do that:

  • ToolsOptionsLibreOfficeFonts: Tick Apply replacement table,
  • Replacement Table:
    • Font: select Segoe UI
    • Replace with: select select the one you want
  • Click the green check mark
  • Tick Always then click Ok


edit flag offensive delete link more


Thank you for that Pierre-Yves. My question was not good-it was the font SIZE I wanted to change! That setting appears to change the font, but not the size. Is there a setting somewhere for the font size?

Piecevcake gravatar imagePiecevcake ( 2017-07-03 03:11:03 +0100 )edit

Hi @Piecevcake - No option managed by LibreOffice. See perhaps via the operating system that handles this mechanism?

pierre-yves samyn gravatar imagepierre-yves samyn ( 2017-07-04 08:05:01 +0100 )edit

I don't think so! In Excel the font of the rows and headers is the font (size, colour, etc) chosen as "normal" in the individual workbook. No other app is going to determine this!

Can anyone else assist with the location of the font size setting?

Piecevcake gravatar imagePiecevcake ( 2017-07-22 19:18:05 +0100 )edit

Question Tools

1 follower


Asked: 2017-06-21 02:02:28 +0100

Seen: 640 times

Last updated: Jul 03 '17