How to Export the Working Trial Balance into Microsoft Excel

How to Export the Working Trial Balance into Microsoft Excel

1. From the 'Navigation Toolbar', click on Trial Balance.

2. Right-Click and Click on "Select all".

3. From the Home tab, select Copy.

4. Launch Microsoft Excel.

5. Highlight the entire spreadsheet and from the main tabs, select Home | Format > Format Cell (Office 2003: From the menus, select Format | Cells) to display the 'Format Cells' dialog. 

6. From the Category list select 'Text'.

7. Click the OK button. 

8. Select cell 'A1' and from the main menu select Edit | Paste.

    • Related Articles

    • Why is my Trial balance balancing in Excel but not in CaseWare

      If your trial balance in Microsoft Excel is balancing well, but not in CaseWare it is likely that there are existing duplicated account numbers within your Excel Spreadsheet. CaseWare Working Papers will only allow unique account numbers to be ...
    • Can CaseWare documents be exported to Microsoft Word & Excel

      CaseWare Working Papers allows users to export CaseWare type documents to Microsoft products. Automatic Documents can be exported to Microsoft Excel. CaseView Documents can be exported to Microsoft Word. Automatic Documents To export automatic ...
    • How do I Change the Colour of the Working Trial Balance

      Users can change the colour scheme of the Working Trial Balance. To do this: 1. From the Tools tab, select Options to display the 'Options' dialog. 2. From the 'Properties' menu select General. 3. From the 'Colour Scheme' picklist select from the ...
    • How do I export Data from a Leadsheet into a Microsoft Excel file?

      Within CaseWare Working Papers, Automatic Documents such as leadsheets are able to be exported into a Microsoft Excel file. Procedure:  Right click on the appropriate automatic document. From the 'Right-click' menus, select Save as > Excel File. The ...
    • How can I use Microsoft Excel to tidy my ASCII Text files

      A direct import from the client's accounting package into CaseWare is not always possible. Therefore, it may be necessary to import the trial balance using the ASCII text file method. It should always be possible to export your client’s trial balance ...