Getting started
Getting started
Get started with Add-In for Excel by defining data in a worksheet and using signatures to create encrypted verification of the workbook.
Note
When working with Add-In for Excel tables, do not attempt to add or remove the standard Microsoft Excel Protect Sheet and Protect
Workbook functions on the Review tab.
Making changes may result in protection being unintentionally altered
on your Add-In for Excel table.
Defining data
Defining data to convert your data to
an Add-In for Excel table.
- With an Excel worksheet active, click the ACL
Add-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 the
last cell in the range, and then click Define Data.
- To select all the data in the worksheet, select an individual
cell 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 as
column headers, clear Use first row as column headers.
- Optional to open the Add-In for Excel table
in a new worksheet, select Create new worksheet and name the worksheet in the ACL
Add-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 table
history.
Signing workbooks
After
you have finalized an Add-In for Excel workbook,
you can verify the workbook by signing it with a digital signature.
- Click the ACL Add-In tab.
- Select Sign Workbook and in the Purpose for signing this document text
box, enter the purpose.
- Verify that the Signing as identity
is correct and click Sign.