How do I make a field compulsory?

Thank you for your response. I've followed the steps exactly (as I did with the previous response) but still nothing happens when I leave the field empty.

HI, Many thanks for replying and so quickly too! Unfortunately it seems to be only a partial solution.

I set it up as described -

and it gives the input message.

but when I move out of the cell nothing happens and the cell is still empty.

Any ideas about what I've done wrong?

Thanks again.

You can try my personal opinion about your question.

If you want to make a field mandatory in Microsoft Excel, you can employ data validation. Here are the steps:

A. Highlight the cell or range of cells that you want to require data entry for.

B. Head to the "Data" tab in the ribbon.

C. Select "Data Validation" in the "Data Tools" group.

D. In the "Data Validation" dialog box, select "Custom" from the "Allow" drop-down menu.

E. Enter a validation formula in the "Formula" field. For instance, to ensure that the cell isn't empty, use the formula: =LEN(A1)>0 (assuming A1 is the selected cell).

F. Customize the error message that will appear if the user tries to leave the cell blank on the "Error Alert" tab.

G. Click "OK" to apply the validation rule. When a user tries to leave the cell blank or enters an invalid value, an error message will display and they will be unable to leave the cell until a valid value is entered.

-usefulman

<removed by Moderator>

Hi Qman

I'm AnnaThomas and I'd be happy to help you with your question. In this Forum, we are Microsoft consumers just like yourself.

To make a field compulsory in Excel using Office 10, you can use the Data Validation feature along with a custom formula. Here's how you can do it:

Select the cells you want to make compulsory.

Go to the "Data" tab in the ribbon and click on "Data Validation".

In the Data Validation dialog box, select "Custom" from the "Allow" dropdown.

In the "Formula" field, enter the following formula: =LEN(A1)>0. Replace "A1" with the first cell in the selected range (for example, if your range starts in cell B2, the formula would be =LEN(B2)>0).

In the "Error Alert" tab, you can customize the error message that will appear when the cell is left blank.

Click "OK" to save the changes.

Now, when you try to leave the cell blank, the error message you specified will appear, and the cell will be highlighted in red. This will enforce the requirement for the field to be filled out.

I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

Best Regards,

AnnaThomas

Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.