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

comparing worksheets

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

Comparing worksheets

ResolvedVersion 2016

Nelson has attended:
Excel Intermediate course

Comparing worksheets

How can i compare two versions of a worksheet to identify changes between them.

RE: Comparing worksheets

Hi Nelson,

Thank you for the forum question.

Unfortunately there is no "magical" tools in Excel which can do this.

I found a video on Youtube with some ideas which may be useful


https://www.youtube.com/watch?time_continue=233& ;v=DyEDODl3e2U&feature=emb_logo


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 27 Nov 2019: Automatically marked as resolved.

Excel tip:

Repeat action

The F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.39 secs.