Ask Your Question

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

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

Piecevcake gravatar image

updated 2017-07-03 03:21:32 +0200

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 close merge delete


upvoted so that you might post a screenshot.

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

1 Answer

Sort by » oldest newest most voted

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

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 +0200 )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 +0200 )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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 558 times

Last updated: Jul 03 '17