Validating Cell Entries - Excel - Microsoft Office Online

Click here to switch to other Office Online sites worldwide

Australia (change) | All Microsoft Sites

	Microsoft Office Excel

Search

	Try the 2007 release Buy the 2007 release
2007 Office system - try and buy

	Get personalised Office help in a newsletter
Discover, learn and share

	Check for updates
Office downloads

Microsoft Office Excel

» Excel Home

Product Information

» Overview

» Top 10 Benefits

» Compare Features

» Try Now

» Buy Now

Help and How-to

» Excel 2007 Help

» Excel 2003 Help

» Excel 2002 Help

» Excel 2000 Help

Choose your version

» Excel Web Access

Training

» Excel 2007 Training

» Excel 2003 Training

» Excel 2007 Demos

» Excel 2003 Demos

Templates

» Templates for Excel

Support and Feedback

» Product Support

» Send Us Your Comments

Technical Resources

» Developer Center

» Office Resource Kit

Additional Resources

» Office Marketplace

» Discussion Groups

Home > Products > Excel > Excel 2003 Help and How-to > Working with Data

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Validating Cell Entries

Documents 1-8 of 8

Page: [1] Go to previous page (disabled)

Copy data validation settings

Change data validation settings

Prevent invalid data entry in a worksheet

Display or hide circles around invalid data

Find cells that have data validation

Remove data validation

Create a drop-down list from a range of cells

Troubleshoot data validation

Documents 1-8 of 8

Page: [1] Go to previous page (disabled)

Related Web Sites

» Product Support
» Microsoft.com

» Microsoft Update
» TechNet

» Office Developer Center
» Office Community

» Office for Mac

Site Help | Accessibility | Contact Us | My Office.com | Office Worldwide Click here to switch to other Office Online sites worldwide