How To Make Multiple Cells Mandatory In Excel Without Vba

To make multiple cells mandatory in Excel without using VBA, you can use Data Validation. Data Validation allows you to set rules and conditions for the data entered in a cell.

Follow the steps below to make multiple cells mandatory:

1. Select the range of cells where you want to apply the mandatory requirement.
2. Go to the “Data” tab in the Excel ribbon.
3. Click on “Data Validation” in the “Data Tools” group.
4. In the “Data Validation” dialog box, select the “Settings” tab.
5. Under the “Allow” dropdown, choose “Custom”.
6. In the “Formula” field, enter a formula that ensures the cell is not blank. For example, you can use the formula =LEN(A1)>0 to check if cell A1 is not empty.
7. Click on “OK” to apply the Data Validation.

Now, when a user enters data in any of the selected cells, Excel will enforce the rule and display an error message if the cell is left blank.

Here is an example:

In the above example, the cells in the “Employee Name”, “Employee ID”, and “Email” columns are set as mandatory using the Data Validation rule. If a user tries to leave any of these cells blank, Excel will show an error message.