Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
833
Consolidating Data from Multiple Users into a Single Workbook
Merge—Click this button to consolidate the data from changing cells into a new work-
sheet. Start in a new worksheet and open the workbooks that contain the scenarios you
want to merge. The Merge Scenarios dialog box lists all open workbooks, and when
you select one, you can pick from a list of worksheets within that workbook (the status
bar tells you whether any scenarios exist in the sheet you’ve selected). Click OK to open
the Scenario Manager dialog box, and then click Show to add the data from the chang-
ing cells to the current sheet. This technique is especially useful when you’ve ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link