How to Change Default Comment Font Size in Excel

Get FREE Advanced Excel Exercises with Solutions!

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. This article will explain how to change default comment font size in Excel.


How to Change Default Comment Font Size in Excel: 2 Easy Methods

This is the dataset for today’s article.

how to change default comment font size in excel

By default, the font is Tahoma and the font size is 9. I will change the font size now.


1. Activate Edit Comment Mode to Change Default Comment Font Size

First, I will show you how to change the default comment font size by activating the edit comment mode.

Steps:

  • First of all, select the cell that has a comment. Here, it is E5.

  • Then, press SHIFT+F2 on your keyboard. Excel will activate the edit comment mode.

Activate edit comment box to change default comment font size in excel

  • Then, go to the Home.
  • After that, change the font size.

  • Excel will change the font size.

Activate edit comment box to change default comment font size in excel

Read More: How to Change Comment Color in Excel


2. Use Format Comment Option to Change Default Comment Font Size in Excel

The next step is to use the Format Comment Option to change the default comment font size.

Steps:

  • First of all, select the cell that has a comment. Here, it is E5.

  • Then, activate the edit mode by pressing SHIFT+F2.
  • After that, right-click your mouse to bring the context menu.
  • Then, select Format Comment.

Format Comment to change default comment font size in excel

  • The Format Comment box will appear.
  • Change the size of the font.
  • After that, click OK.

  • Excel will change the font size.

Format Comment to change default comment font size in excel


Things to Remember

  • The default font type is Tahoma and the size is 9.
  • You can change other characteristics too using these 2

Download Practice Workbook

Download this workbook and practice while going through the article.


Conclusion

In this article, I have explained 2 easy methods to alter the default comment font size in Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo