Ask Your Question

LibreOffice Calc - Macro to increase/decrease Cell Font Size

asked 2019-12-01 07:39:11 +0100

GaXve gravatar image

updated 2019-12-01 07:45:11 +0100

In Excel, I found this Macro that allows you to Increase/Decrease cell Font Size of active cell (using Keyboard Shortcuts).

Is there a way to recreate something similar in LibreOffice?

  • Sub MakeBigger()
    • Selection.Font.Size = Selection.Font.Size + 1
  • End Sub
  • Sub MakeSmaller()
    • Selection.Font.Size = Selection.Font.Size - 1
  • End Sub
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-12-01 10:09:46 +0100

There's dedicated Increase function that increases font size by 2 pts (not 1) - you may bind it to any keyboard shortcut using ToolsCustomize; search for "Increase" typing it in the search box on Keyboard tab, and use the last of the three displayed "Increase" functions. Ditto for "Decrease" (but iiuc, it's the second of the three "Decrease" functions. Confusing to have three identical names for three different functions, I know. tdf#129122).

edit flag offensive delete link more


Wow! Thank you!!! Quick question though, why is the increment 2 rather than 1?

GaXve gravatar imageGaXve ( 2019-12-02 03:19:08 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-12-01 07:39:11 +0100

Seen: 32 times

Last updated: Dec 01