SmartViewForExcelOpen Excel workbooks in separate windows and view them side by side This week we continue exploring new features in Excel 2. This post is brought to you by Chad Rothschiller, a Program Manager in the Excel Team. How do I open my workbooks in separate windows This has been a common inquiry from many of our customers who want to look at their workbooks side by side, or spread them across more than one monitor. Smart View For Excel' title='Smart View For Excel' />Good news starting with Excel 2. Word and Power. Point today. That means that each workbook has its own ribbon and top level window frame that you can move and resize independent from your other open workbooks. This functionality can improve multitasking, visibility, and analysis across workbooks. In computing terminology, this is called Single Document InterfaceSDI. Versions of Excel before the 2. Smart View For Excel' title='Smart View For Excel' />Multiple Document Interface MDI, where all workbook windows were contained within a top level master container window. Heres an example of four new workbooks. Note that each one has its own window and ribbon How to arrange your windows. Worldleading glass software specifically designed for glass businesses to quote, design, manage and more Manage all aspects of your business with one system. Now that you have multiple windows, how should you arrange them Well, there are plenty of options and below are some favorites Smart Snapping Grab the top of the window, and drag it to the top, left, or right edge of your screen, then let go. The window automatically resize Drag Left Position on the left half of the screen. Drag Right Position on the right half of the screen. Drag Top Fills the entire screen. Windows Taskbar If you hold down the Shift Key and then right click the Excel icon on the Windows Task Bar you will see options for arranging your open windows. The cool thing about these options is that if you have multiple monitors, Windows remembers each workbooks monitor and arranges workbooks displayed within the same monitor. VIEW THE FULL LUXLIVE PROGRAMME. Copyright 2017 Revo Media and PennWell Corporation Tulsa, OK. All Rights Reserved Privacy Policy Terms Conditions. Excel Ribbon Click on View the Arrange All to see more options for arranging your workbooks Note that you can still create new windows or multiple windows showing the same workbook. Similarly, the View Side by Side and Synchronous Scrolling features work just like they used to. Tell us what you think. Thanks for learning more about this new feature in Excel 2. The Art Of Electronics Horowitz &Amp. I hope you all get wonderful benefits from being able to arrange workbooks on your screens  In a future post, well go into a couple more advanced topics such as Merging Instances and Long Running Operations and how they work with pre existing add ins. In the meantime, let us know in the comments how youre planning to use this new feature or anything else youd like to see in future versions. Chad Rothschiller, Excel Program Manager.