Did You Know:: Synchronized Scrolling, Comparing Workbooks Side by Side

Posted: May 26, 2013 by MaxFraudy in Excel
Tags: ,

UntitledIn some situations, we need to compare two worksheets/workbooks, e.g. Sales report from two different weeks or months, or we might need to compare two versions of a template/report. In such situations, using [Alt] + [TAB] to switch between windows is tiresome as well as annoying.

Did you know that you could compare two or more windows side by side and even synchronize their scrolling? This is how it’s done:

Go to View tab -> Window group -> View Side by Side. Click the Synchronous Scrolling button to scroll them at the same time.

View Side by Side

Advertisements

Share your thoughts/feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s