Excel - Can You View 2 Sheets Side By Side In Excel - Episode 1985
Microsoft Excel Tutorial - Arrange Worksheets Side by Side.
Welcome to another episode of the MrExcel podcast, where we dive into all things Excel. In this episode, we'll be discussing how to compare two sheets side by side. If you're new here, make sure to subscribe to the MrExcel Excel playlist for more helpful tips and tricks.
So, let's say you have two different sheets in your workbook, January and February, and you need to compare them. Sure, you can use the CTRL+PgDn and CTRL+PgUp shortcut keys to switch between sheets, but what if you need to see them side by side? Well, here's a nifty trick for you.
First, go to the View tab and select "Side by Side" and then enable "Synchronous Scrolling". This will allow you to see both sheets at the same time and scroll through them simultaneously. But wait, there's more! By using the "New Window" option under the View tab, you can create two windows of the same workbook, each showing a different sheet. Think of it as having two cameras looking at different sections of the workbook.
Now, to arrange these windows side by side, you can either use the "Arrange All" option and select "Vertical", or simply use the "View Side by Side" option. The advantage of using the latter is that it automatically turns on Synchronous Scrolling, ensuring that both sheets scroll together. This is especially useful when comparing rows and columns.
But what if you need to compare two different workbooks? Well, you can still use the same trick by opening both workbooks and using the "Arrange All" or "View Side by Side" options. This is a great way to quickly compare data without having to use complex formulas like VLOOKUP.
I want to give a special shoutout to Ann Walsh for sending in this tip. She has also written a fantastic beginner's book called "Your Excel Survival Kit - A Guide To Surviving and Thriving in the Excel World". If you know someone who's new to Excel and needs some guidance, this book is a must-read.
And that's it for this episode. We hope you found this tip helpful and will use it to make your Excel experience even better. Don't forget to hit that subscribe button and stay tuned for more netcasts from MrExcel. Thanks for watching!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents:
(00:00) Comparing sheets side by side
(00:22) Using shortcut keys to navigate between sheets
(00:32) Using View Side by Side and Synchronous Scrolling
(01:00) Using New Window to create 2nd View of Workbook
(01:40) Advantages of using View Side by Side
(02:15) Comparing two different workbooks
(03:23) Episode Recap
(03:33) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelcompare
This video answers these common search terms:
can you put sheets side by side in excel
how to see two sheets side by side in excel
how to put 2 sheets side by side in excel
how to open two excel windows side by side
how to view 2 sheets side by side in excel
can you view 2 sheets side by side in excel
how to have two tables side by side in excel
how to view excel pages side by side
how to open two excel sheets side by side
how to view two excel sheets side by side
how do you view side by side in excel
how to view tabs side by side in excel
how to show two sheets side by side in excel
how to open excel sheets side by side
how to put 2 excel sheet side by side
how to put 2 excel sheets side by side
how to show 2 excel sheets side by side
how to do side by side sheets in one excel
how do i view side by side excel
how to put two sheets side by side in excel
how to open 2 excel files side by side
how to work on 2 different excel sheets side by side
how to do synchronous scrolling excel
View, Arrange All, Vertical lets you compare workbooks side by side. But what if you have to compare two worksheets in the same workbook? Episode 1985 shows you how to use New Window and View Side by Side to eyeball two worksheets. Episode Recap:
Ctrl+PgDn and Ctrl+PgUp switch between sheets
Create a second window with the workbook using View, New Window
This creates a :2 version of the workbook
View, Arrange All, Vertical
First click selects window. Second click does the sheet
To have them scroll together, use View Side by Side
Toggle Synchronous Scrolling if rows are not lined up
:2 version is not a new workbook
It is a second camera looking at a different part of the workbook
This tip sent in by Anne Walsh
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Watch video Excel - Can You View 2 Sheets Side By Side In Excel - Episode 1985 online without registration, duration hours minute second in high quality. This video was added by user MrExcel.com 12 August 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,25 once and liked it 4 people.