Change default Color, Shape, Font of Comment Box in Excel
Here's how to change default Color, Shape, Font of Comment Box in Excel.
i. To change the default comment shape in Excel, follow these steps:
1. Open the Excel workbook that contains the comments you want to change.
2. Click on the **File** tab.
3. Click on **Options**.
4. In the **Excel Options** dialog box, click on the **Advanced** tab.
5. In the **Display** section, scroll down to the **Comments** section.
6. Select the **Use a custom shape for comments** check box.
7. In the **Shape** drop-down list, select the shape you want to use for comments.
8. Click on the **OK** button.
All new comments that you insert will now use the shape you selected.
To change the shape of existing comments, follow these steps:
1. Select the comment you want to change.
2. Click on the **Home** tab.
3. In the **Font group**, click on the ** arrow** next to the **Shape** button.
4. Select the shape you want to use.
The shape of the selected comment will be changed.
Here are some additional tips for changing the default comment shape in Excel:
* You can also change the default comment color and font by following the steps above and selecting the appropriate options in the **Comments** section of the **Excel Options** dialog box.
* If you want to change the shape of a single comment, you can do so by selecting the comment and then clicking on the **Format Comment** button in the **Developer** tab. In the **Format Comment** dialog box, click on the **Shape** tab and select the shape you want to use.
* You can also create custom comment shapes by using the **Shape Outline** and **Shape Fill** tools in the **Format Comment** dialog box.
ii. Here are the steps on how to change the default font for a text box in Excel:
1. Open the Excel workbook that contains the text boxes you want to change.
2. Click on the **Insert** tab.
3. In the **Text group**, click on the **Text Box** button.
4. Draw a text box in the worksheet.
5. Click on the **Home** tab.
6. In the **Font group**, click on the **arrow** next to the **Font** box.
7. Select the font you want to use.
8. Click on the **OK** button.
All new text boxes that you insert will now use the font you selected.
To change the font of existing text boxes, follow these steps:
1. Select the text box you want to change.
2. Click on the **Home** tab.
3. In the **Font group**, click on the **arrow** next to the **Font** box.
4. Select the font you want to use.
5. Click on the **OK** button.
The font of the selected text box will be changed.
Here are some additional tips for changing the default font for a text box in Excel:
* You can also change the default font size and color for text boxes by following the steps above and selecting the appropriate options in the **Font** group.
* If you want to change the font of a single text box, you can do so by selecting the text box and then clicking on the **Format Text Box** button in the **Format** group. In the **Format Text Box** dialog box, click on the **Font** tab and select the font you want to use.
* You can also create custom fonts for text boxes by using the **Font** tool in the **Format Text Box** dialog box.
iii. To change the default text box font in PowerPoint, follow these steps:
1. Open the PowerPoint presentation that contains the text boxes you want to change.
2. Click on the **View** tab.
3. In the **Master Views** group, click on the **Slide Master** button.
4. On the Slide Master tab, click the **Fonts** drop-down menu.
5. Select the font you want to use for all the text boxes in the presentation.
6. Click **Close Master View**.
All new text boxes that you insert will now use the font you selected.
To change the font of existing text boxes, follow these steps:
1. Select the text box you want to change.
2. In the **Home** tab, in the **Font** group, click the **arrow** next to the **Font** box.
3. Select the font you want to use.
4. Click **OK**.
The font of the selected text box will be changed.
Here are some additional tips for changing the default text box font in PowerPoint:
* You can also change the default font size and color for text boxes by following the steps above and selecting the appropriate options in the **Font** group.
* If you want to change the font of a single text box, you can do so by selecting the text box and then clicking on the **Format Text Box** button in the **Format** group. In the **Format Text Box** dialog box, click on the **Font** tab and select the font you want to use.
* You can also create custom fonts for text boxes by using the **Font** tool in the **Format Text Box** dialog box.