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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |