Excel Tip Tuesday: More about How to Arrange Windows

Posted by Lisa on January 22, 2019 at 10:30 AM

Excel IconLast 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.

Excel Tips - Arrange Windows 2-1

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.

Excel Tips - Arrange Windows 2-2

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.

Topics: Excel, Excel Tip Tuesday

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

  • There are no suggestions because the search field is empty.

Recent Posts

Posts by Topic

see all