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