From the course: Excel: Productivity Tips

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Synchronous scrolling across multiple workbooks

Synchronous scrolling across multiple workbooks - Microsoft Excel Tutorial

From the course: Excel: Productivity Tips

Start my 1-month free trial

Synchronous scrolling across multiple workbooks

“

- [Instructor] Alright and our next pro tip sounds pretty fancy, but it's actually quite basic. We're going to talk about comparing two files or Excel workbooks using something called synchronous scrolling, and basically, what synchronous scrolling is, it's a way to arrange two Excel workbooks side-by-side and have the ability to scroll through them both at the same time. So we're going to follow a few quick steps in this demo. We're going to open up two workbooks that we want to compare. They're going to be identical. We're going to go into our view tab and activate view side-by-side, as well as synchronous scrolling, and what that's going to do is allow us to scroll through both windows at the exact same time. So a few common use cases here. It's good for spot checking workbooks to test for version control issues or make some quick high level visual comparisons between files that share similar formats and layouts.…

Contents