The SDI now used in Excel 2013 makes it easier to compare multiple spreadsheets side by side.
Previous releases of Excel used the Multiple Document Interface (MDI), in which all spreadsheet windows opened under a top-level, “master” container window. That means that each spreadsheet has its own Ribbon and title bar so you can move the window around and resize it independently from your other open spreadsheets. This will allow you to scroll through both windows using the scroll bar on one of them.Įach spreadsheet opening in its own window, like in Word and PowerPoint, is called Single Document Interface (SDI). It's like doing two jobs at the same time. This enables you to run slow processes in one instance whilst still working in another.
How to snap to grid excel 2013 how to#
If you want to scroll through both (or all) spreadsheets at the same time, you can turn on the Synchronous Scrolling option in the Window section of the View tab. Click the Home tab in Ribbon Go to the Drawing group Click the Align button, and go on to click Align item in the drop down menu Click the Grid Setting button The Grid and Guides dialog box will pop up, and you will view the Snap to Grid feature as the figure 2 shows. Learn how to create multiple independent instances of Excel. If you have more than two spreadsheets open, Tiled will arrange them as tiles on the screen some horizontally, some vertically, depending on how many are open.Ĭascade displays the spreadsheet windows with the title bars cascaded down the screen. Tiled does the same thing as Vertical when there are two spreadsheet windows open.
Select Vertical to view the windows side by side, as you did when you snapped them to the sides of the screen.