Introduction
Your analysis is not limited to just a single table with the SAC add-in. You can add multiple tables to a sheet or workbook with a click of a button.
Add an Additional Table
To add an additional table to a sheet or workbook, be sure to select a cell within the sheet and click the Add Table button.
Note
Where you select the cell for the additional table matters. In order to ensure that you do not break or overwrite an existing table, you must select a cell with at least two empty columns to the right and three empty rows to the bottom.
Avoiding Content Overwrite
During your analysis, you may need to expand/collapse rows and/or columns. The SAC add-in will recognize what may be overwritten and will provide you with options on how to proceed. Whatever you choose, you always have the option to redo an action step from the Builder panel.
| Content | Option(s) |
|---|---|
|
Table, Formula, Data Action |
• Crop changed element and cut the rest of it • Cancel action |
|
Text, Excel Formulas |
• Crop changed element and cut the rest of it • Overwrite existing content • Cancel action |
Warning displayed if your action will overwrite an existing table, formula, or data action.
Warning displayed if your action will overwrite existing text or an Excel formula.
Switching Between Tables
If you need to quickly navigate between different tables that are in a sheet, you can use the Named Range drop-down menu located next to the formula bar.
