This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I thought I used to hover over a cell and it would show me the formula in that cell, but now it's not doing it. How do I get that back? Thank you
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Perhaps you did it with VBA
Adds a Comment showing formula in cell
Sub comment_cellformula()
'single cell formula into a Comment
Selection.AddComment (Left(Selection.Formula, Len(Selection)))
End Sub
Gord
OK, maybe I'm recalling incorrectly (it has been a long day) :)
Thank you for your reply.
I have never seen that in Excel. Perhaps you had a custom add-in that you used for that.