Friday, 20 January 2023

Cell Message in Excel

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
  1. First, select the cell to which you want to add a message.
  2. After that, go to the Data Tab ➜ Data Tools ➜ Data Validation ➜ Data Validation.
  3. In the data validation window, go to the Input Message tab.
  4. Enter the title, and message, and make sure to tick mark “Show input message when the cell is selected”.
  5. In the end, click OK.
excel tips tricks create cell message

Once the message is shown you can drag and drop it to change its position. 

No comments:

Post a Comment