Cell Comments And Notes

Home/Data Handling/ Cell Comments And Notes

Cell Comments and Notes

Put a sticky note on a cell

By Neale Blackwood

You can put a comment on a cell by right clicking the cell and selecting Add Comment. This displays a pop up box (like a post it note) whenever the mouse hovers over the cell. If you want a popup to display each time the cell is selected you use data validation.

First select the cell, then click the Data menu and select Data Validation. Click the Input Message tab and enter a heading and text in the spaces provided and click OK. The message will display each time the cell is selected.

This is a useful documentation feature for cells that may only be populated once a month or less frequently and you need a note to specify where the data comes from or how it is calculated.

First published: CPA AUSTRALIA Website 2009

2017-03-08T03:54:06+00:00 Data Handling|