Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
662
Chapter 24 Excel Essentials
Restricting and Validating Data Entry for a Cell
or Range
When designing a worksheet, you’ll occasionally want to restrict the type of data users can
enter in a specific cell or range. Excel lets you define data-validation rules for cells and
ranges to do exactly that. Examples of useful applications include the following:
In a list of recent sales results formatted to show only month and date, restrict entry in
a specific column to only dates within the last month. This technique prevents users
from inadvertently entering a date in the wrong month or year, or in the future.
On a budget worksheet, require that the user ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link