Forum Discussion
Excel and the refernce function - why 'comments' for a cell do not transfer
Excel 2013.
When I reference a cell between sheets in the same document, the comments do not carry to the copy-to cell.
For example, on my November sheet cell d34 has a comment. In my December sheet, where I reference that cell, the 'copy-to' cell reads "November2019!D34", however, the comment does not show, only the otherwise visible cell contents.
What am I not doing, or is the program not capable of showing the comment?
Thanks
1 Reply
- This is by design, a cell comment is fixed to a cell and cannot be pulled in using a formula.
