Select the cells you want to create a rule for. Select Data >Data Validation On the Settings tab, under Allow, select an option: Whole Number: To restrict the cell to accept only whole numbers. …