How to change default comment format in Excel?

In default, the comment format in Excel is shown as below, and if you want to change this default comment format to more colorful and lively in Excel, you can do as this tutorial introduced.

doc-change-default-comment-1

Change default comment format

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

arrow blue right bubble Change default comment format


If you want to change default comment format, you need to go to the Personalize dialog first, then change the advanced setting. Please do as follow steps:

1. Place the cursor on a blank place of the desktop and right click to open context menu and click Personalize. See screenshot:

doc-change-default-comment-2

2. Click Window Color button on the bottom of the dialog. See screenshot:

doc-change-default-comment-3

3. Then click Advanced appearance settings to enter Window Color and Appearance dialog. See screenshot:

doc-change-default-comment-4

4. Click ToolTip form the Item list, then specify the background color, the font, font color, the font size and font color of the comment format. Also you can decide if the font is bold or italic.

doc-change-default-comment-5

5. Click Apply or OK to apply the new setting in your computer. Then click Save Changes to save the setting and close the dialog.

Now the default comment format is changed.

doc-change-default-comment-6

Note: Applying this method will affect all tool tips of the computer.

Tip: If you are using Windows 8, you can change the default comment formats as following:

(1) Right click blank place at desktop, and select the Personalize from the context menu;

(2) In the popping up Personalization folder, click the Display in the left bar;

(3) In the Display folder, go to the Change only the text size section, click the first box and select the Tooltips from the drop down list, and then change the font size in the next box. Here you can also bold all text in comments.

(4) Click Apply.

doc-change-default-comment-7
doc-arrow
doc-change-default-comment-8

Relative Articles:


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    ahmadabi787@gmail.com · 1 years ago
    Thanks for sharing this information with us.
    Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.
    If anyone faces TV issues connect https://www.techsupportdubai.com/lg-tv-repair/
  • To post as a guest, your comment is unpublished.
    unstablend@gmail.com · 1 years ago
    I think this is main system of any computer system caused My computer desktop windows is arranging all things in properly and with quality so you have to any http://mycomputerwindows10.com issue with this system then come here and solved your problems in few seconds.