O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Merging Multiple Workbooks into a Single Workbook

When you have multiple versions of a workbook that you've shared with Track Changes on, you can merge them into a single workbook.

NOTE: You must turn on the Track Changes feature, as discussed earlier in this chapter, before you can merge workbooks. Until Track Changes is on, the Merge Workbooks command is unavailable.

To merge the workbooks, follow these steps:

  1. Open the workbook into which you want to merge the changes.
  2. Choose Tools images Merge Workbooks to display the Select File to Merge into Current Workbook dialog box. Despite its long name, this is a standard dialog box for selecting files, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required