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:
![excel tips tricks create cell message display](https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/images/optimized/rev-a53ee6c/wp-content/uploads/2018/06/excel-tips-tricks-create-cell-message-display.png)
- 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.
![excel tips tricks create cell message](https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/images/optimized/rev-a53ee6c/wp-content/uploads/2018/06/excel-tips-tricks-create-cell-message.png)
Once the message is shown you can drag and drop it to change its position.
No comments:
Post a Comment