Microsoft Office Tutorials and References
In Depth Information
3. On the View tab, in the Window group, click Switch Windows and then, in the
list, click JanuaryCalls .
The JanuaryCalls workbook is displayed.
4. Select the cell range C5:O13 , and then click the Expand Dialog button.
The Consolidate dialog box is restored to its full size.
5. Click Add .
The range you selected appears in the All References pane.
6. Click the Collapse Dialog button at the right edge of the Reference field.
The Consolidate dialog box contracts.
7. In the Switch Windows list, click FebruaryCalls .
The FebruaryCalls workbook is displayed.
8. Select the cell range C5:O13 , and then click the Expand Dialog button.
The Consolidate dialog box is restored to its full size.
9. Click Add .
The range ‘[FebruaryCalls.xlsx]February’!$C$5:$O$13 appears in the All References
pane.
Search JabSto ::




Custom Search