How do we change the default font settings in the comments box in Excel 2019?

driving is fun

New Member
Joined
Feb 8, 2018
Messages
12
I have little to add here, but it seems there was a way to do this in Excel 2016 ( I haven't tried as I don't have that version) but any methods suggested did not work in Excel 2019.

I have changed the default font setting for Excel 2019 but that only affects the main font in the cells, it hasn't changed the comment box font.

Any help would be much appreciated.
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

driving is fun

New Member
Joined
Feb 8, 2018
Messages
12
I don't have a code. I just want to change the default font in the comments box.
When I insert a comment in a cell (Review>New comment) the default font is Tahoma, size 11, bold. I want to change this default font setting.
 

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,760
Office Version
  1. 365
Platform
  1. Windows
That's exactly what's discussed on this web page!

" When you add a comment to a cell, Excel automatically uses the Tahoma style font in size 9 on a PC, and size 10 on a Mac. You can change the formatting for a comment, and in Windows you can also or change the default format for all comments. "
 

driving is fun

New Member
Joined
Feb 8, 2018
Messages
12
I can change the formatting in the comments box, I know. But I want to change the default from Tahoma-bold to something else. Otherwise I have to change the formatting each time I insert a comment.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,121
Messages
5,576,213
Members
412,708
Latest member
AD04
Top