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.
Download Practice Workbook
Download this workbook and practice while going through the article.
2 Easy Methods to Change Default Comment Font Size in Excel
This is the dataset for today’s article.
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.
- Then, go to the Home
- After that, change the font size.
- Excel will change the font size.
Read More: Creating and Editing Comments in Excel (4 Practical Examples)
Similar Readings
- How to Remove Pop-up Comments in Excel (4 Suitable Ways)
- [Fixed!] Comments in Excel Far Away from Cell (3 Possible Solutions)
- Vlookup to Copy Comments in Excel (with a UDF)
- How to Export PDF Comments into an Excel Spreadsheet (3 Quick Tricks)
- How to Print Worksheet with Comments in Excel (5 Easy Ways)
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.
- The Format Comment box will appear.
- Change the size of the font.
- After that, click OK.
- Excel will change the font size.
Read More: How to Reset Comment Position in Excel (With Easy Steps)
Things to Remember
- The default font type is Tahoma and the size is 9.
- You can change other characteristics too using these 2
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. Please visit Exceldemy for more useful articles like this.
Related Articles
- Anchoring Comment Boxes in Excel (With 3 Easy Ways)
- How to Export Facebook Comments to Excel (2 Easy Ways)
- How to Add a Comment on a Graph in Excel (3 Easy Methods)
- [Solved!] Comments Are Not Displaying Properly in Excel
- [Fixed!] Excel Comment Only Showing Arrow
- How to Hide All Comments in Excel (3 Simple Methods)