Did you know that you can leave notes on specific Excel cells for people to read? It’s a great way to safeguard against data entry mistakes by putting in reminders or instructions. Here’s how to set it up:
- Click on the cell where you want the note.
- Go to the Data tab at the top.
- Click Data Validation in the Data Tools Group.
- In the window that opens, go to the Input message tab.
- Check the box that says “Show input message when cell is selected.”
- Add a title (32 characters).
- Type your input message (255 characters).
- Click OK.

To help other users fill in the form, you can integrate hints into individual cells that appear automatically when you click on them.
IDG
https://www.pcworld.com/article/2778484/how-to-integrate-helpful-input-notes-into-excel-cells.html
Войдите, чтобы добавить комментарий
Другие сообщения в этой группе

A splash of color? Think bigger. With its latest light, Signify-owned


In recent months, a long list of issues with the classic Outlook app

One of the most annoying things about getting a battery-powered video

A few years ago, Microsoft introduced the Feedback Hub, an app that a

It’s great when you can charge up your devices in your car, and most

Mammotion, a major player in the robot lawn mower market, is expandin