Tag Archives: default

Excel: How to change the default to a comment

We explain how to change the way that default Microsof Excel applies to comments you enter on this worksheet. Thus, you can customize to your liking any of these comments.

Excel How to change the default to a comment

1: Change the way previous versions to 2007

In versions prior to Office 2007, the process to be carried out to change the default of a review is quite simple: all you have to do is display the comments and click right on its edge.

Excel How to change the default to a comment

Then, from the toolbar drawing of the bottom of the screen, you just had to click the button drawing and entry Change AutoShape. Then choose from the available new.
Excel How to change the default to a comment

The effect and the change is immediate. The comment might be:
Excel How to change the default to a comment

2: Customize the ribbon from Office 2007

From Office 2007, to change the form of a comment, you could for example set the timely entry into the ribbon. To do this, from the main screen of Excel (in this case Excel 2010) click File, Options and Customize Ribbon . Then choose the input all commands and locates at the bottom entry Change form.

Excel How to change the default to a comment

Then clicking on the tab name and group of the ribbon where you want to include the new command (for the shape change of the comment). We will include it in the record Insert in the section Illustrations.
Excel How to change the default to a comment

Now enter a descriptive name for the new entry and press the button OK.
Excel How to change the default to a comment

Then, still select the input on the left side called (Reshape), click Add and then OK.

Excel How to change the default to a comment

3: Use the comment and changes its shape

Next will be to enter a comment in the usual way. Then, click on its border to select and access with a click of the tab Insert ribbon top option.

Excel How to change the default to a comment

There, in paragraph Illustrations . You will find a new entry (icon) available.
Excel How to change the default to a comment

Clicking on it, so any changes that are displayed comment may experience.

Excel How to change the default to a comment

Click on one (in the cloud) and see her new look immediately.

Excel How to change the default to a comment

4: Change the color of a comment

In case you need to also remember that you can change the color commentary via the context menu. To do this, you just click again on the edge of the comment with the right mouse button and select the input format of the comment. On the tab colors and lines, you’ll find multiple functions related to the change in format. The corresponding color change is first.

Excel How to change the default to a comment

For example it may well be (in the second case, we applied a gradient of two colors):
Excel How to change the default to a comment

Excel How to change the default to a comment