Objective:
Guide for applying data validation in Excel for Mac.


Steps:

  1. Select Data Range

    • Highlight the range of cells you want to apply validation to.

  2. Set Validation Rules

    • Go to Data > Data Validation, and set rules such as restricting input to numbers or dates.