How To View Two Sheets Side-by-side In The Same Excel File

Learn how to setup Excel to view two sheets side-by-side in the same workbook using the New Window feature. This technique is great for writing formulas, copying and pasting data, or comparing two or more sheets. It saves time from having to navigate between two tabs that are not close to each other in the workbook.

I explain shortcuts to setup the split screen view, and how to use Synchronous Scrolling to visually compare two different sheets with similar data.

Additional resources:

00:00 Introduction
00:24 New Window
00:59 Split Window
02:14 Synchronous scrolling
03:38 Close Windows
04:19 Outro

[JBMatyourservice]

The pivot charts and tables had help me a lot. Then, I find myself watching all your videos. Thanks for the free training. More power.

[chaujay]

After using excel for a decade, I finally realise this amzing function!!!Thanks!!!It's very practical and effcient especially in dual monitor!!!

[rogerthat]

I've been using this for a few years now and love it. I've taught my colleagues about this and they were amazed.

[qman]

This is definitely a game changer. Really wanted this feature for a while. Thank you for the quick video.

[geoff]

OMG I cant believe I didn't know about this. My live is change forever Jon. Thank you

[jameskig]

Thank you so much Mr. Jon. Your videos are blessing to me. They Make me understand a subject so easily compared to other excel videos from other people. God bless you soooo much.

[RobinFoster-zz]

Thank you so much! This was so helpful in using a workbook with a macro that runs based off of a =FILTER query on another tab. It was hard to continue to flip the pages repeatedly and I wasn't aware that this feature was available. So useful!

[danielcousins]

Clear, concise exactly what I was looking for, great job

[andresdelarosa]

Appreciate the help! This makes Studying for my Excel Final way more manageable!

[olamoyegunoreofe]

I came across this after five years of sharing the video.

Thanks for the insight

[mitchelblum-alexander]

Thanks for the video - told me exactly what I was trying to find out

[SHANKSY]

Excellent Jon. Most helpful and time saving.

[a.j.wilkes]

Fundamentals! I just brought this into a coworker's life last week, trying to troubleshoot a SUMIFS and not wanting to flip between 10 tabs.

[catmanal]

Thank you so much. Really helpful and the first video that came up in a Bing search.

[russlightfoot]

This is awesome. I need this almost every day. My work around has been to pull one of the sheets into a second workbook. The problem, of course, is that formula writing becomes VERY cumberdone

[LAHenrys]

This is exactly what I needed. Thank you!

[mikeiz]

Thank you! This helped me greatly. Very well explained and to the point. Thanks again.

[Naucratesable]

Great, exactly what I was looking for! Thank you!

[jaynehemmings]

Excellent tip!! This is my life on a daily basis... :)

[kenmcmillan]

Great tip. Really appreciate you sharing. Very helpful!!