Methods to add useful prompts to Microsoft Excel cells
Tip
Improve your spreadsheets by offering on-the-spot directions.
Picture: AVM
Do you know which you can go away notes on particular Excel cells for folks to learn? It’s an effective way to safeguard towards knowledge entry errors by placing in reminders or directions. Right here’s tips on how to set it up:
- Click on on the cell the place you need the word.
- Go to the Knowledge tab on the high.
- Click on Knowledge Validation within the Knowledge Instruments Group.
- Within the window that opens, go to the Enter message tab.
- Examine the field that claims “Present enter message when cell is chosen.”
- Add a title (32 characters).
- Kind your enter message (255 characters).
- Click on OK.
To assist different customers fill within the type, you may combine hints into particular person cells that seem mechanically once you click on on them.
IDG
This text initially appeared on our sister publication PC-WELT and was translated and localized from German.
Writer: Roland Freist, Contributor, PCWorld
Roland Freist is a contract IT journalist protecting matters associated to Home windows, functions, networks, safety and the Web.
