Let’s say you need to add a specific message to a cell, like “Don’t delete the value”, “enter your name” or something like that.
In this case, you can add a cell message for that particular cell. When the user will select that cell, it will show the message you have specified. Here are the steps to do this:
- First, select the cell to which you want to add a message.
- After that, go to the Data Tab ➜ Data Tools ➜ Data Validation ➜ Data Validation.
- In the data validation window, go to the Input Message tab.
- Enter the title, and message, and make sure to tick mark “Show input message when the cell is selected”.
- In the end, click OK.
Once the message is shown you can drag and drop it to change its position.
No comments:
Post a Comment