Microsoft Office Tutorials and References
In Depth Information
Converting a range to a table
11 Choose File > Save, and then choose File > Close.
The following table lists the data validation settings you can choose from.
SETTING
DESCRIPTION
Any value
Removes any previous restrictions and cancels data validation
Whole number
Restricts the entry to a whole number that falls within a certain range
or adheres to parameters that you specify
Decimal
Restricts the entry to a decimal number that falls within a certain
range or adheres to parameters that you specify
List
Restricts the entry to a list that you choose
Date
Restricts the entry to a date that falls within a certain range or on or
before a particular date
Time
Restricts the entry to a time that falls within a certain range or on or
before a particular time of the day
Text length
Restricts a text entry so that its length in characters is neither below
nor above a certain number, or falls within a range that you specify
Custom
Restricts the entry to the parameters specified by a particular formula
entered in another cell of the worksheet
Converting a range to a table
You can apply the Excel table tools to any range by converting a range to a table. You can
then add, edit, and sort data in that table.
To open the i le you need for this lesson:
1
Choose File > Open and navigate to the Excel07lessons folder.
2
Click excel0703 and then click Open.
3
Select File > Save As. Excel displays the Save As dialog box.
4
In the Save As text box, type excel0703_done and then click Save.
Search JabSto ::




Custom Search