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
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
Transcript of the video:
Hey, I'll be podcasting this entire book, go ahead subscribe to the MrExcel Excel playlist.
Lear Excel with MrExcel podcast, episode 1985 - Compare Sheets Side by Side!
Alright, so here's the deal, we have two different sheets in this workbook, January and February, I need to compare the two of them, you go back and forth.
Well.
First off, let's just use CTRL+PgDn to go to the right, or CTRL+PgUp to go to the left, couple of great shortcut keys there.
It'll save you from using the mouse, but if I really need to be able to see, the side by side and compare them row by row, a beautiful trick out here on the View tab.
So we're going to ultimately use View Side by Side, and then Synchronous Scrolling.
And I want to show you those while the screen's wide here, because the screen's about to get less wide.
First thing I'm going to do, I'm in Podcast1985, I'm going to do New Window, alright, which creates two windows, one called 1985:1, and one called 1985:2, Is this two different workbooks?
No!
Think of it as two different cameras, looking at different sections of the workbook.
So 1985:1, I can look at January, and in 1985:2 I can look at February.
Alright, now it's just a matter of arranging these, alright, so typically, I would always do Arrange All, and then Vertical.
That way I can see them side-by-side, horizontal will be above and below.
If you just do view side by side, it depends on the size of your screen, whether you get going to get horizontal or vertical.
The advantage, however, of doing view side by side, is that it automatically turns on this one, which is called Synchronous Scrolling.
And the advantage of that, alright, so first off, let's just, it's kind of amazing, over here on the left hand side I have January, on the right hand side I have February, so I can see both sheets, from the same workbook, side by side.
But, as I start to scroll, all right, you see that they are both scrolling together, except one of them has freeze panes and the other one doesn't.
Let me go here and Freeze Panes on both.
Alright, so now we're all seeing row 1, row 2, I start to scroll, I'm using the mouse, see, it's just a little bit out of sync.
Alright, so we turn off Synchronous Scrolling, we get it back into sync, Access Analytic on the top of both.
Turn on Synchronous Scrolling and now when I scroll, Areef Ali, Budget Wand, GL Wand, JEV- something got out of sync there.
But that's correct, it actually is out of sync, someone added a row, or deleted a row, alright?
So I turn off the Synchronous Scrolling, I get it back into sync.
So we'll put JEVS at the top of both, Turn on Synchronous Scrolling.
So if you need to compare two sheets, should you be doing a VLOOKUP to compare these?
Probably.
But sometimes you just need to eyeball something, right?
And this is a great way to do it.
Now, the :2 version.
We have the :1 and :2.
Again, it's not two workbooks.
When we want to exit this mode, you click here, this X, I always thought this X was Close Workbook, but it's not, it's Close Window.
So I have two windows open, I can close that one, and we go back to just the original view.
Now, this is two sheets side by side.
If you need to look at two different workbook side by side, You can skip that whole thing with the new window, you can just open them both, Arrange All, or the new View Side by Side.
Hey, it's Friday, that means for about half the world it's payday, great day to go to shopping.
If you're looking for something to buy, here's a subliminal suggestion.
Recap of this episode: We talked about CTRL+PgDn and PgUp, to switch between sheets.
Create a second window with a workbook, using View, New Window and that creates a :2 version.
We can either do View, Arrange All, Vertical, or, the View Side By Side.
In order to have them scroll together, you have to choose Side by Side, make sure Synchronous Scrolling is on.
So January in one window, February in the other window.
It's not a second workbook, it's just a second camera looking at the workbook.
Hey, this tip, sent in by Ann Walsh.
Ann Walsh sent me this tip, and then later on, went on to write this great beginner’s book, about Excel, called "Your Excel Survival Kit - A Guide To Surviving and Thriving in the Excel World".
If you know someone who's been thrown into a job, where they're drowning in a sea of spreadsheets, and they don't have the Excel skills, this great book by Ann will help.
I want to thank Ann for this tip, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Lear Excel with MrExcel podcast, episode 1985 - Compare Sheets Side by Side!
Alright, so here's the deal, we have two different sheets in this workbook, January and February, I need to compare the two of them, you go back and forth.
Well.
First off, let's just use CTRL+PgDn to go to the right, or CTRL+PgUp to go to the left, couple of great shortcut keys there.
It'll save you from using the mouse, but if I really need to be able to see, the side by side and compare them row by row, a beautiful trick out here on the View tab.
So we're going to ultimately use View Side by Side, and then Synchronous Scrolling.
And I want to show you those while the screen's wide here, because the screen's about to get less wide.
First thing I'm going to do, I'm in Podcast1985, I'm going to do New Window, alright, which creates two windows, one called 1985:1, and one called 1985:2, Is this two different workbooks?
No!
Think of it as two different cameras, looking at different sections of the workbook.
So 1985:1, I can look at January, and in 1985:2 I can look at February.
Alright, now it's just a matter of arranging these, alright, so typically, I would always do Arrange All, and then Vertical.
That way I can see them side-by-side, horizontal will be above and below.
If you just do view side by side, it depends on the size of your screen, whether you get going to get horizontal or vertical.
The advantage, however, of doing view side by side, is that it automatically turns on this one, which is called Synchronous Scrolling.
And the advantage of that, alright, so first off, let's just, it's kind of amazing, over here on the left hand side I have January, on the right hand side I have February, so I can see both sheets, from the same workbook, side by side.
But, as I start to scroll, all right, you see that they are both scrolling together, except one of them has freeze panes and the other one doesn't.
Let me go here and Freeze Panes on both.
Alright, so now we're all seeing row 1, row 2, I start to scroll, I'm using the mouse, see, it's just a little bit out of sync.
Alright, so we turn off Synchronous Scrolling, we get it back into sync, Access Analytic on the top of both.
Turn on Synchronous Scrolling and now when I scroll, Areef Ali, Budget Wand, GL Wand, JEV- something got out of sync there.
But that's correct, it actually is out of sync, someone added a row, or deleted a row, alright?
So I turn off the Synchronous Scrolling, I get it back into sync.
So we'll put JEVS at the top of both, Turn on Synchronous Scrolling.
So if you need to compare two sheets, should you be doing a VLOOKUP to compare these?
Probably.
But sometimes you just need to eyeball something, right?
And this is a great way to do it.
Now, the :2 version.
We have the :1 and :2.
Again, it's not two workbooks.
When we want to exit this mode, you click here, this X, I always thought this X was Close Workbook, but it's not, it's Close Window.
So I have two windows open, I can close that one, and we go back to just the original view.
Now, this is two sheets side by side.
If you need to look at two different workbook side by side, You can skip that whole thing with the new window, you can just open them both, Arrange All, or the new View Side by Side.
Hey, it's Friday, that means for about half the world it's payday, great day to go to shopping.
If you're looking for something to buy, here's a subliminal suggestion.
Recap of this episode: We talked about CTRL+PgDn and PgUp, to switch between sheets.
Create a second window with a workbook, using View, New Window and that creates a :2 version.
We can either do View, Arrange All, Vertical, or, the View Side By Side.
In order to have them scroll together, you have to choose Side by Side, make sure Synchronous Scrolling is on.
So January in one window, February in the other window.
It's not a second workbook, it's just a second camera looking at the workbook.
Hey, this tip, sent in by Ann Walsh.
Ann Walsh sent me this tip, and then later on, went on to write this great beginner’s book, about Excel, called "Your Excel Survival Kit - A Guide To Surviving and Thriving in the Excel World".
If you know someone who's been thrown into a job, where they're drowning in a sea of spreadsheets, and they don't have the Excel skills, this great book by Ann will help.
I want to thank Ann for this tip, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
