How to Export the Working Trial Balance into Microsoft Excel
Procedure:
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 ...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 ...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 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 ...