Dennis Faas's picture

Adding Comments to a Formula in MS Excel

Sometimes you would just love to have a comment that would make things clearer for the person using the worksheet in MS Excel, wouldn't you? Well you can use this handy little trick to add a comment to a formula in MS Excel: At the end of your ... formula, add a plus sign (+), to the N function, and an open parentheses. Key in your comment in quotation marks. Close the parentheses. You can view the comment in the formula bar whenever you select the cell. When you become a member at, you have access to this and many, many more articles that include screenshots. Don't delay: ... (view more)

Dennis Faas's picture

Add A Chart to a Comment: MS Excel

There may be times when you want to display a chart with your data using MS Excel, but you don't want it to take up the space on the worksheet. One solution is to place the chart in a document. First, create your chart and cut and paste it to a ... drawing program such as Paint. Save the chart as a picture file and then go back and insert a comment in the worksheet. To add the chart to the comment, follow these steps: Double-click the comment. Select the Colors and Lines tab. In the Fill section, select Fill Effects from the Color drop-down list. Select the Picture tab and then click the Select ... (view more)

Subscribe to RSS - comment