Office
 

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.

 
Others
 
- 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
- Microsoft Word 2010 : Adding Supplementary Elements - Creating a Bibliography
- Microsoft Word 2010 : Adding Supplementary Elements - Figure Captions & Adding a Table of Figures
- Microsoft Visio 2010 : Tips for Creating Organizational Charts
- Microsoft Visio 2010 : Tips for Creating Timelines
- Microsoft PowerPoint 2010 : Prepare for Delivery - Rehearsing Presentations
- Microsoft PowerPoint 2010 : Prepare for Delivery - Adapting Presentations for Different Audiences
- Microsoft Excel 2010 : Analyzing Worksheet Data - Creating Groups and Outlines, Converting Text to Columns
- Microsoft Excel 2010 : Analyzing Worksheet Data - Charting a PivotTable
- Microsoft Outlook 2010 : Managing a Calendar - Setting Up a Meeting
- Microsoft Outlook 2010 : Managing a Calendar - Adding an Event
 
 
Most View
 
- SQL Server 2012 : Authorizing Securables - Permission Chains, Object Ownership, Securables Permissions
- Sharepoint 2013 : Organizing and managing information - Creating a new content type
- Microsoft Visio 2010 : Laying Out Shapes (part 3) - Fine-tuning Layout
- Microsoft Visio 2013 : A Visual Orientation to a Visual Product - Identifying new features of Visio 2013
- Windows Server 2012 : Business continuity for virtualized workloads (part 1) - Implementing Hyper-V Replica
- Windows Server 2012 : Installing and Configuring FTP Services (part 1) - IIS 8 FTP Server Service Features , Installing the FTP Server
- Overview of Oauth in Sharepoint 2013 : Application Authentication (part 2) - Managing Tokens in Your Application
- Developing, Integrating, and Building Applications in Sharepoint 2013 (part 2) - User Interface Integration - App Parts and Pages
- Microsoft Project 2010 : Project on the Internet (part 1) - Hyperlinking to Information - Creating a Hyperlink to a File or Web Page
- Sharepoint 2013 : Use Managed Metadata Navigation in a Publishing Site (part 2) - Editing a Term Set for Navigation in a Site
 
 
Top 10
 
- Microsoft PowerPoint 2010 : Working with Charts - Modifying and Formatting Charts (part 3) - Formatting Charts
- Microsoft PowerPoint 2010 : Working with Charts - Modifying and Formatting Charts (part 2) - Modifying Your Chart’s Layout
- Microsoft PowerPoint 2010 : Working with Charts - Modifying and Formatting Charts (part 1) - Modifying Chart Design
- Microsoft PowerPoint 2010 : Working with Charts - Inserting a Chart from Excel
- Microsoft PowerPoint 2010 : Working with Charts - Inserting Charts
- Microsoft PowerPoint 2010 : Working with Charts - Understanding Charts
- Sharepoint 2010 : Windows PowerShell Remoting (part 2) - Entering a Remote Session, Running SharePoint 2010 Cmdlets Remotely
- Sharepoint 2010 : Windows PowerShell Remoting (part 1)
- Sharepoint 2010 : Windows PowerShell Scripts (part 3) - Writing Comment-Based Help Topics in Scripts,Using Functions in Scripts , Customizing Windows PowerShell with Profile Scripts
- Sharepoint 2010 : Windows PowerShell Scripts (part 2) - Executing Scripts, Using Parameters in Scripts