Last week, we looked at how to arrange numerous Excel workbooks without have to spread windows out all over the place. But what if you want to arrange multiple worksheets in the same workbook. Can’t be done, right? Wrong! You can definitely do it! Heres's how.
On the ribbon's View tab, click on the New Window button.
Next, click on the View Side by Side button. You will have the same workbook open, but you can now compare two different worksheets. As you can see below, the same workbook name is open, but I’m showing two worksheets right next to each other.
And you have the same options available to turn on or off Synchronized Scrolling as you had when you were viewing different workbooks side by side. Pretty cool, huh?
So however you'd like to look at your data, Excel's options for arranging your workbook views should make that task incredibly easy.
Leave us a comment and let readers know what Excel tips you use on a daily basis.