How to create custom Input & Error Messages In Excel

    In Excel, customized enter or error messages clarify the principles for every discipline to forestall data-entry errors. Think about, as an example, that it is your job to create, preserve, and assign person IDs and passwords to your firm workers. You create a spreadsheet to carry out this job. Then you definitely get transferred. So now you must delegate this job to another person. The easiest way to make sure the job is finished proper is to create enter and error messages. 

    For the Consumer IDs, first create an Error Alert that claims, “No duplicates allowed.” Then create an Enter Message that, when displayed, explains what sort of information may be entered. And final, a backup Error Message for column E that claims: “Solely 7 digits allowed.”

    Create an Error Alert in Excel

    1. Enter the next column headers on columns A via G: Gross sales Workers, Consumer IDs, Passwords, Legitimate Dates, Consumer IDs, Passwords, Legitimate Dates (once more).

    2. Set the width of column A to 24. Enter a dozen person names in column A (from A2 via A13 is satisfactory). 

    three. Change the column widths of B via G to 12: House > Format > Column Width 12, then click on OK.

    four. Spotlight B2:B13.

    5. From the DATA tab, click on the Knowledge Validation button, then choose Knowledge Validation from the drop-down checklist.

    6. When the Knowledge Validation dialog field seems, choose the Settings tab, then click on the tiny arrow beside the Permit discipline field, and choose Customized from the drop-down checklist.

    Recent Articles

    Related Stories

    Stay on op - Ge the daily news in your inbox