ExcelBanter - MS Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - MS Excel 2007 (https://www.excelbanter.com/excel-worksheet-functions/196663-ms-excel-2007-a.html)

how do I annotate a formula in a cell in MS Excel 2007?

Do you mean add a comment? Right-click on the cell and choose Insert
Comment.

Hope this helps.

Pete

On Jul 29, 12:36*am, sherrysboyfriend
wrote:
how do I annotate a formula in a cell in MS Excel 2007?

When you say "formula", do you literally mean that?

You can add a comment to a *formula*, but it will only be visible in the
formula bar when you click in that cell.

=Sum(A1:A10)+N("Comment Here")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"sherrysboyfriend" wrote in
message ...
how do I annotate a formula in a cell in MS Excel 2007?