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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

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,774
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,122,755
Messages
5,597,929
Members
414,193
Latest member
bb60

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top