Defining data
Defining data to convert your data toan Add-In for Excel table.You can define an entire worksheet, or a subset or range of datawithin a worksheet.
See Also
Data types in Data ModelsEnter data manually in worksheet cellsThe Types of Cell ElementsConvert a data type - Microsoft SupportBenefits of defined data
- Data is read-only, protecting it from accidental changes
- Formats the data consistently
- Optionally opens the selected data in a new worksheet
- Freezes the column headers so they remain visible while youscroll through the data
- Enables Excel sorting and filtering in column headers
- Displays totals of numeric data
- Displays table, column, and row details in the ACLAdd-In panel
Define data using Add-In for Excel
- With an Excel worksheet active, click the ACLAdd-In tab.
- Do one of the following:
- To select a range of data you want to define,click the first cell in the range and then drag to thelast cell in the range, and then click Define Data.
- To select all the data in the worksheet, select an individualcell containing data and click Define Data,and then click Define Data.
Tip
You can also use Ctrl+a to select all and then click Define Data.
- Optional to not use the first row of data ascolumn headers, clear Use first row as column headers.
- Optional to open the Add-In for Excel tablein a new worksheet, select Create new worksheet and name the worksheet in the ACLAdd-In worksheet name field.
- In the Data Source Description field, enter a description and then click OK.
The description is displayed in the Add-In for Excel tablehistory.
Undefine data
Undefine data to remove the data protection and formatting from an Add-In for Excel table and convert it to a standard EXcel worksheet. The table history is permanently removed however row statuses, computed columns, and the content of the Notes column are retained.
- With a cell selected in the Add-In for Excel table,click the ACLAdd-in tab.
- Click Undefine Data and then click Yes in the confirmationdialog box.
