Use View, New Window to allow comparing two worksheets of the same workbook side by side.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel for MrExcel, Podcast Episode 1818: Compare 2 Worksheets Side By Side.
That's right.
I said worksheets, not workbooks.
Comparing two workbooks side by side -- View, Arrange All.
I think a lot of people know how to do that but what if we want to compare the original worksheet and the revised worksheet side by side?
What we're going to do is we're going to do View, New Window.
Now, notice, before I do that, there's no colon up here in this file name, but when I do New Window, I'm now looking at :2, and when I Switch Windows, there's a :1 version and a :2 version.
This is two different views of the exact same workbook.
So, when we do Arrange All, Vertical, click OK, now, on the left-hand side, I can look at our original, and on the right-hand side, I can look at revised.
One strange bug that I noticed here is the Freeze Panes is getting turned off when we do this on the one side and not the other.
So, we'll get those so that we can see the left and the right.
Is this two different workbooks?
No.
It's the exact same workbook.
The other interesting thing here, and this goes back to Excel 2003, if we use the View Side by Side, it automatically turns on or enables Synchronous Scrolling, so that way, when we scroll one side, the other side scrolls.
Now, what happens here when we get new data on one side and not the other?
Well, now they're all out of sync, this red row and this red row.
Well, here's what we'll do.
We will get that red row up to the top, turn off Synchronous Scrolling temporarily, and on the left, get the red row so that way they are both together, turn on Synchronous Scrolling, and now row 51 on the left and row 46 on the right are tied together.
Again, it is not two different versions of the workbook.
It's the same version.
This is also handy.
I’ve heard of people say, “I want to look at the top of the spreadsheet on the left and the bottom of the spreadsheet on the right,” and we can do that.
Make changes on the left, type something over here, and those changes appear on the right, so you don't have to worry about saving two different versions.
It's just one version.
When you're done with this, come over to the :2 version, and click the X to Close Window, and everything is back in the original file, viewing two workbooks side by side using a new window.
Alright. Hey, I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Learn Excel for MrExcel, Podcast Episode 1818: Compare 2 Worksheets Side By Side.
That's right.
I said worksheets, not workbooks.
Comparing two workbooks side by side -- View, Arrange All.
I think a lot of people know how to do that but what if we want to compare the original worksheet and the revised worksheet side by side?
What we're going to do is we're going to do View, New Window.
Now, notice, before I do that, there's no colon up here in this file name, but when I do New Window, I'm now looking at :2, and when I Switch Windows, there's a :1 version and a :2 version.
This is two different views of the exact same workbook.
So, when we do Arrange All, Vertical, click OK, now, on the left-hand side, I can look at our original, and on the right-hand side, I can look at revised.
One strange bug that I noticed here is the Freeze Panes is getting turned off when we do this on the one side and not the other.
So, we'll get those so that we can see the left and the right.
Is this two different workbooks?
No.
It's the exact same workbook.
The other interesting thing here, and this goes back to Excel 2003, if we use the View Side by Side, it automatically turns on or enables Synchronous Scrolling, so that way, when we scroll one side, the other side scrolls.
Now, what happens here when we get new data on one side and not the other?
Well, now they're all out of sync, this red row and this red row.
Well, here's what we'll do.
We will get that red row up to the top, turn off Synchronous Scrolling temporarily, and on the left, get the red row so that way they are both together, turn on Synchronous Scrolling, and now row 51 on the left and row 46 on the right are tied together.
Again, it is not two different versions of the workbook.
It's the same version.
This is also handy.
I’ve heard of people say, “I want to look at the top of the spreadsheet on the left and the bottom of the spreadsheet on the right,” and we can do that.
Make changes on the left, type something over here, and those changes appear on the right, so you don't have to worry about saving two different versions.
It's just one version.
When you're done with this, come over to the :2 version, and click the X to Close Window, and everything is back in the original file, viewing two workbooks side by side using a new window.
Alright. Hey, I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
