It’s easy and you can do it in less than a minute!
Choose the cells that you want to attach a note to and choose Data Validation from the Data ribbon (shortcut: Alt > D > L). Select the tab “Input Message” and type whatever you want. Click OK, and your message will appear when you select the cell.
Of course, you can combine this with some restrictions on the Settings tab, but you don’t need to.
More easy Excel tricks:
- Shortcut: Open Format Cells Dialog Box
- How to Summarize Hours in Excel and Show the Right Result
- Create a search field in Excel in 5 minutes
Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.