» Summing Monthly Trial Balance Figures
CATEGORY - Excel Consolidating
VERSION - All Microsoft Excel Versions
1. Define Names for each of the Trial Balances as follows: Select a cell within the January Trial Balance, press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to select the region, and then press Ctrl+F3 to define the Name TB_Jan.
2. Repeat step 1 for the February Trial Balance and define a Name for TB_Feb.
3. Select a cell, and from the Data menu, select Consolidate.
4. In the Reference box, press F3.
5. In the Paste Name dialog box, select TB_Jan, click OK, and then click Add to add TB_Jan to All references.
6. Press F3 again and add TB_Feb to All references.
7. In Use Labels in, select the Top row and Left column checkboxes, and then click OK.
The Consolidated Trial Balances:
Book Store:
Recommended Books:
- Mortgages For Dummies®
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Special Edition Using Microsoft Word 2002
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Microsoft Office XP Step-By-Step (With CD-ROM)
No comments have been submitted.
