Making them larger will allow for easier modifications. Move the icons to allow a fair amount of distance between them.

For this tutorial, we will be using the “ tablet” icon from the “ Technology and electronics” category and the “ checklist” icon from the “ Business” category.

From the icon library, select the icon(s) that suit your needs.

Insert an icon by selecting Insert (tab) -> Illustrations (group) -> Icons.

Launch PowerPoint and create a new blank presentation with a blank slide.

The steps to achieve this are as follows: Because of this Excel limitation, we will utilize PowerPoint to create and capture the background image. Unfortunately, Excel will allow us to perform all but one of the steps necessary to achieve this result. We will then apply it as a background for our comment box. We will achieve this by selecting and capturing as a file an icon from the icon library. Sadly, most users of comments don’t drift beyond the default appearance of a comment.įor the more adventurous of us, we can right-click on a comment border and select Format Comment or use the CTRL-1 keyboard shortcut.Īside from the font, font size, font color customizations, we can also select the Colors and Lines tab of the Format Comment dialog box to access many creative cosmetic features.Īn interesting way to get visually creative comments is to add a background image to the comment. This will generate an extra sheet at the end of your printout listing all the comments, comment authors and cell locations. If we return to the Page Setup dialog box, click the dropdown for the Comments feature and select “ At end of sheet”. Keep in mind, the comments will only be printed if they are rendered visible on the sheet by one of the previously discussed methods. Click the option labeled “ As displayed on sheet (legacy)”.

Select the Sheet tab then select the dropdown list for the Comments feature. Since the ribbon has limited screen real estate, these buttons take you to the full feature lists in the applicable category. This will launch the Page Setup dialog box. If you wish to print the comment next to the cell containing the comment, select the Page Layout tab and click on any of the Dialog Box Launcher buttons in the lower right of any supported button group. There are two methods for printing the comments in a worksheet.

How to remove excel shortcut keys