HDTutorial
EN
How to Validate Data in Excel 2016 - How to Set Restrictions to Entered Values

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Validate Data in Excel 2016 - How to Set Restrictions to Entered Values

4,107 views October 27, 2017 2:05

Watch on YouTube
ChannelExcel, Word and PowerPoint Tutorials from Howtech

Description from the creator

In this HowTech written tutorial, we’re going to show you how to validate data in Excel 2016.
Don't forget to check out our main channel youtube.com/c/HowTech for more free how-to videos!
Join us on Facebook
Facebook.com/howtechtv
Our App
bit.ly/how-tech
To start, select the cell or range of cells to validate data in. Go under the Data tab and click Data Validation then Data Validation again.

Set the parameters you want. You can allow whole numbers, lists, dates, and so on. You will need to have a minimum and maximum for most options. Click OK when finished.

This is a HowTech tutorial, visit our website and watch our videos for more.

About this tutorial

Excel, Word and PowerPoint Tutorials from Howtech published this 2:05 video tutorial on October 27, 2017. It has been watched 4,107 times on YouTube.

Duration
2:05
Published
October 27, 2017
Views
4,107
Likes
22

Share

This tutorial in other languages