comparing spreadsheets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Comparing spreadsheets

Comparing spreadsheets

resolvedResolved · Low Priority · Version 2003

Amanda has attended:
Excel Intermediate course
Excel Advanced course

Comparing spreadsheets

How to identify discrepencies between two different spreadsheets

RE: comparing spreadsheets

Hello Amanda

Thank you for your question and welcome to the forum.

There is a feature called Compare and Merge in Excel, which you can use to compare one spreadsheet against another. In order for this to work though, you need to make the workbook shared first (Tools - Share Workbook, then tick the Allow changes by more than one user box).

The Compare and Merge feature is designed to be used so that if you have multiple copies of the same workbook, you can compare one workbook against another and then decide how you want to merge data from one workbook into another.

I hope this helps.
Amanda

Fri 12 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips


Server loaded in 0.08 secs.