We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

For licensed users of Accounting CS Workpapers

Use the following procedure to define columns in a custom Microsoft Excel worksheet that is created from within Accounting CS Workpapers.

1. In the Workpapers Dashboard, double-click the spreadsheet workpaper to open it in Microsoft Excel.
2. Click the Workpapers CS add-in ribbon, and then choose Properties .

   Note: The Properties command is not available in the Workpapers CS add-in ribbon for Microsoft Excel workpapers that are added as external or blank documents via the Add Workpapers wizard within Accounting CS Workpapers.

3. Select the column that you want to define in the grid.
4. Select a column type from the drop-down list for the selected column, and enter a custom heading.

   Note: If you do not enter custom heading text, the application will use the default column headings.

5. Select the amount properties (amount type, balance type, period, and year) in the Type Definition section.
6. Choose the page orientation. Mark the Landscape checkbox to set the workpaper orientation to landscape, or leave it cleared for portrait.
7. Click Next.

Was this article helpful?

Yes No

Submit