When you create worksheets that will be used by others, it’s important to make sure they can only enter valid data. Use Excel’s data validation features to make rules to restrict the type of data or values that others can enter into a cell. Learn more at the Office 365 Training Center: http://office.com/training
Copilot
VIDEO
17 July 2018
How to validate cell data in Microsoft Excel
When you create worksheets that will be used by others, it’s important to make sure they can only enter valid data. Use Excel’s data validation features to make rules to restrict the type of data or values that others can enter into a cell....
