Change The Format Of Text In Sticky Note Comments

This is the placeholder for an optional "sub" headline.
BY STANLEY ZAROWIN

Q. Is there a way to change the format of Comments, which are attached like sticky notes to an Excel cell?

A. Yes, you can easily change the font and type style in individual Comments or, with a few extra steps, change the default setting for all ToolTips, which is what a Comment is.

To change an existing Comment format, put your cursor over the cell, which will show a red triangle to indicate the Comment’s presence, and right click. Select Edit Comment in the following menu:

Now highlight the words you want to reformat and again right click. That will bring up this menu:

Click on Format Comment to bring up the menu below and proceed to format the text.

Although there is no way within Excel to change the default characteristics, you can make changes in Windows. However, any change in Windows will affect the ToolTips in all your other Microsoft applications. Here are the steps:

Minimize or close all applications and right click on any area of the desktop itself to evoke the Windows’ Context menu. Click on Properties .

That brings up the Display Properties menu.

Click on the Appearance tab, and in the Items drop-down list, select ToolTip and use the Font and Size controls to select the characteristics you want. Click on OK .

SPONSORED REPORT

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out