a feature in Excel that is applied to control what data a user can enter into a cell<\/strong>.<\/p>\n\n\n\nWe can use data validation input messages for example to instruct data entry personnel to enter numeric values in a cell that are within a given range, text entries that are less than a certain number of characters, or dates that occur within the next certain number of days.<\/p>\n\n\n\n
How to create data validation input message<\/h2>\n\n\n\n When we create worksheets that other people will use, it is important to set up data validation input messages<\/strong> that will make it easy for them to understand what to do with the dataset.<\/p>\n\n\n\nTo set up a data validation input message<\/strong> that pops up when a cell is selected in Excel we use the followings steps:<\/p>\n\n\n\n\nSelect the cell in which we want to enforce data validation.<\/li>\n\n\n\n Choose Data >> Data Tools >> Data Validation<\/strong> on the Ribbon to launch the Data Validation<\/strong> dialog box:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nClick on the Input Message<\/strong> tab, put a checkmark in the checkbox next to Show input message when cell is selected<\/strong>:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nType in the title for the input message in the Title<\/strong> box, type in the data validation input message we want to be displayed when the cell is selected in the Input Message<\/strong> box, and click OK<\/strong>:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe Input Message in the yellow box<\/strong> appears when we select the cell in which we are enforcing data validation:<\/p>\n\n\n\n <\/figure>\n\n\n\nHow to edit or change the data validation input message<\/h2>\n\n\n\n Sometimes when situations or circumstances change, we may want to edit or change the validation input message.<\/p>\n\n\n\n
We use the following steps when we want to edit or change the validation input message:<\/p>\n\n\n\n
\nSelect the cell which has the data validation input message.<\/li>\n\n\n\n Choose Data >> Data Tools >> Data Validation<\/strong> from the Excel Ribbon<\/strong>:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nIn the Data Validation<\/strong> dialog box, make the needed changes or edits in the Title<\/strong> box and \/or the Input message <\/strong>box and click OK:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe updated data validation input message<\/strong> now appears in the selected cell:<\/p>\n\n\n\n <\/figure>\n\n\n\nHow to remove the data validation input message<\/h2>\n\n\n\n Sometimes we may want to remove the data validation input message(s) from our dataset.<\/p>\n\n\n\n
We use the following steps to achieve this:<\/p>\n\n\n\n
\nSelect the cell from which we want to remove the data validation input message.<\/li>\n\n\n\n Choose Data >> Data Tools >> Data Validation<\/strong> from the Excel Ribbon<\/strong> to launch the Data Validation<\/strong> dialog box:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nClick the Clear All<\/strong> button in the Data Validation <\/strong>dialog box and then click OK:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nWhen we now select the cell the data validation message no longer appears because it has been removed.<\/p>\n\n\n\n
Sometimes we do not want to remove the data validation input message but just stop it from showing when the cell. We use the following steps to achieve this:<\/p>\n\n\n\n
\nSelect the cell in which we want to stop the input message from showing.<\/li>\n\n\n\n Go to Data >> Data Tools >> Data Validation<\/strong> on the Excel Ribbon<\/strong> to launch the Data Validation <\/strong>dialog box:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nRemove the checkmark<\/strong> from the checkbox next to Show input message when cell is selected<\/strong> and then click OK:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe data validation input message no longer shows when the cell is selected.<\/p>\n\n\n\n
Additional information<\/h2>\n\n\n\n The input message size cannot exceed 255 characters<\/strong>. The size of the message box is set by Excel and cannot be changed.<\/p>\n\n\n\nLocation of data validation input message<\/h3>\n\n\n\n Generally, the input message box appears below the cell with the left border in the middle of the cell\u2019s width:<\/p>\n\n\n\n <\/figure>\n\n\n\nThe input message however can appear in different positions around the cell depending on the location of the cell and whether it contains a comment:<\/p>\n\n\n\n
\nIf the cell is close to the right border of the Excel window, the right edge of the input message will begin at the border of the Excel window<\/strong>:<\/li>\n<\/ul>\n\n\n\n <\/figure>\n\n\n\n\nIf there isn\u2019t sufficient space below the cell or to the right of the cell, the input message will appear at the top of the cell:<\/li>\n<\/ul>\n\n\n\n <\/figure>\n\n\n\n\nIf there isn\u2019t enough space below the cell or to the left side of the cell, the data validation input message pops up to the right of the cell:<\/li>\n<\/ul>\n\n\n\n <\/figure>\n\n\n\n\nIf the cell has a comment, the input message appears below the cell with its right border in the middle of the cell\u2019s width:<\/li>\n<\/ul>\n\n\n\n <\/figure>\n\n\n\n\nIf the cell has a comment and there isn\u2019t enough space on the right, the data validation input message is chopped off. This problem generally occurs in cells that are in Column A:<\/li>\n<\/ul>\n\n\n\n <\/figure>\n\n\n\nMoving the data validation input message<\/h3>\n\n\n\n When the data validation input message pops up, we can drag it to a different location on the worksheet, though temporarily:<\/p>\n\n\n\n <\/figure>\n\n\n\nAll<\/strong> the data validation input messages in the worksheet will move to the temporary new location.<\/p>\n\n\n\nWhen we close and reopen the worksheet, the data validation input messages will return to their original locations.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n In this tutorial, we have learned that the yellow box<\/strong> with information that sometimes pops up when we select a cell in a dataset where data validation is enforced is a data validation input message<\/strong>. It is a custom message designed to instruct those who use the worksheet to enter data into the worksheet correctly. It is part of data validation<\/strong> which is a feature in Excel that is applied to control what data a user can enter into a cell<\/strong>.<\/p>\n\n\n\nWe have looked at how to create the data validation input message, how to change or edit the data validation message, and how to remove the data validation message.<\/p>\n\n\n\n
We looked at the different factors that can change the location of the data validation message in the worksheet. The factors include whether the cell has a comment or sufficient space on the right side, left side, or at the bottom of the cell. We can also temporarily move the data validation input messages to a different location in the worksheet.<\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes when you select a cell in an Excel dataset that has data validation enforced, a yellow box pops up with certain information….<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Yellow Box in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n