Thursday, 14 November 2024

"DO NOT TYPE ANYTHING IN THIS CELL" on excel

To create a note like the one shown in your Excel screenshot, you can use the Comment or Data Validation feature. Here’s how to do each:

Method 1: Using a Comment

1. Right-click the cell where you want the message to appear.


2. Select New Comment (or Insert Comment in older versions).


3. Type your message (e.g., "DO NOT TYPE ANYTHING IN THIS CELL").


4. Click outside the cell to save the comment.


5. A small red triangle will appear in the corner, indicating a comment. Hovering over it will display the message.



Method 2: Using Data Validation

1. Select the cell you want to restrict.


2. Go to the Data tab, and select Data Validation.


3. In the Data Validation dialog box, go to the Input Message tab.


4. Check Show input message when cell is selected.


5. Enter your title (e.g., "DO NOT TYPE") and message (e.g., "DO NOT TYPE ANYTHING IN THIS CELL").


6. Click OK.



This will display a message box whenever the cell is selected.

No comments:

Post a Comment