excel tip

Input Restriction

Similar to the data validation feature, there’s another way to restrict input values and offer guidance to other users adding to your spreadsheet. To ensure data outside of a given range is barred from your sheet, go to “Data,” then “Data Validation,” then “Setting,” and input your desired conditions. You can also shift to “Input message” and provide prompts that steer users to the correct data range, which will show up when their cursor hovers over the cell and trigger a warning message if the value is unqualified.