Excel 2016 Tips and Tricks
Excel 2016
Lesson 2 – Working with Tables
7. Select the Data
list dropdown.
8. Select the desired option. 9. Enter the desired limits. 10. Select or deselect the Ignore Blank option, as desired. 11. Select OK .
S TEP - BY -S TEP From the Student Data directory, open TABLE2.XLSX . Use data validation to restrict data entry.
Steps
Practice Data
1. Select the column data for which you want to restrict data entry. The column data is selected.
Click above Year
2. Select the Data tab.
Click Data
The Data tab is displayed.
3. Select the left-hand part of the Data Validation button in the Data Tools group. The Data Validation dialog box opens.
Click
4. Select the Settings tab.
Click Settings , if necessary
The Settings page is displayed.
5. Select the Allow list.
Click Allow
A list of options is displayed.
6. Select the desired option.
Click Whole number
The desired option appears in the Allow box.
7. Select the Data list.
Click Data
A list of options is displayed.
8. Select the desired option.
Click between
The desired option appears in the Data box and one or more boxes (depending on the option selected) appear below the Data box for entering limit values.
OFFICEPRO, Inc.
Page 55
Made with FlippingBook flipbook maker