Microsoft Excel 2010 : Analyzing Worksheet Data - Adding Data Validation to a Worksheet

11/26/2011 3:37:08 PM
Worksheet cells can be adjusted so that only certain values can be entered. Controlling how data is entered decreases errors and makes a worksheet more reliable. You might, for example, want it to be possible to enter only specific dates in a range of cells. You can use logical operators (such as equal to, not equal to, less than, or greater than) to set validation rules. When invalid entries are made, a message—developed and written by you—appears indicating that the entry is in violation of the validation rules. The rule set will not allow data to flow into the cell.

Create Validation Rules

Select the range you want covered in the validation rules.

Click the Data tab.

Click the Data Validation button.

Click the Settings tab.

Click the Allow list arrow, and then select a value type.

Options vary depending on the Allow value type you select.

Click the Data list arrow, and then select a logical operator.

Enter values or use the Collapse Dialog button to select a range for the minimum and maximum criteria.

Click the Input Message tab, and then type a title and the input message that should be displayed when invalid entries are made.

Click the Error Alert tab, and then select an alert style, type a title, and error message.

Click OK.

To view invalid data, click the Data Validation button arrow, and then click Circle Invalid Data. To clear the circles, click the Data Validation button arrow, and then click Clear Validation Circles.

- Microsoft Outlook 2010 : Inserting Items, Objects, and Files in a Calendar Item
- Microsoft Outlook 2010 : Updating Calendar Information
- Microsoft OneNote 2010 : Adjusting OneNote Performance Settings
- Microsoft OneNote 2010 : Enabling or Disabling Automatic Wiki Link Creation
- Microsoft Project 2010 : Exchanging Data Between Programs - Copying Information
- Microsoft Project 2010 : Sharing Resources Among Projects
- Microsoft Access 2010 : DATA ACCESS WITH ADO (part 4) - Working with Data in Recordsets
- Microsoft Access 2010 : DATA ACCESS WITH ADO (part 3) - Navigating Recordsets
- Microsoft Access 2010 : DATA ACCESS WITH ADO (part 2) - Creating Recordsets
- Microsoft Access 2010 : DATA ACCESS WITH ADO (part 1) - Using the Execute Method
- First look: Apple Watch

- 10 Amazing Tools You Should Be Using with Dropbox

- Sigma 24mm f/1.4 DG HSM Art

- Canon EF11-24mm f/4L USM

- Creative Sound Blaster Roar 2

- Alienware 17 - Dell's Alienware laptops

- Smartwatch : Wellograph

- Xiaomi Redmi 2
Popular tags
Video Tutorail Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
Top 10
- How To Install Windows Server 2012 On VirtualBox
- How To Fix Skype High CPU And Memory Usage In Windows 8
- Add 270 Additional Cleaning Options To CCleaner With CCEnhancer
- FPPT Provides More Than 2000 Free And Attractive PowerPoint Templates
- Setup Free Media Server To Stream Videos To DLNA Compatible TV, Xbox 360 & PS3 (Play Station 3)
- How To Install Android Market & Google Apps On Kindle Fire
- How To Make Ubuntu Look Like Windows 7
- How To Add A New Account in MS Outlook 2013
- Get Android & Mac OS X Style Gadgets For Windows 7 & Windows 8 With XWidget
- How To Activate Microsoft Office 2013