شنبه یازدهم مرداد ۱۳۹۹ - 13:51 - حسين حسين پور -
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 for 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 title, message and make sure to tick mark “Show input message when the cell is selected”.
- In the end, click OK.
Once the message is showed you can drag and drop it to change its position.