FICPAYou Are Here:
Excel 2013 Allows Viewing Spreadsheets Side-by-Side in Separate Windows
If you've been considering an upgrade to Office 2013 from Office 2007 or Office 2010, there's one feature definitely worthwhile: Excel 2013 now displays multiple open spreadsheets in their own window, which lets you view them side-by-side, snap them to either side of the screen, etc. You'd think the ability to easily compare workbooks side-by-side would have made it in to one of the eight major releases over the last 28 years.
Fortunately, with Excel 2013, there's no need to fuss around in the View ribbon. Simply open two Excel spreadsheets and snap them to either side of the screen. Easy!
The View ribbon is still available, as is the View Side by Side option. To use it, open two spreadsheets, then click View –> View Side by Side.
By default, this will arrange your windows horizontally.
You may want to collapse the ribbon (CTRL + F1) to get a little bit more viewing space.
To arrange the windows differently, click Arrange All.
This will give you a few different options: Tiled, Horizontal, Vertical and Cascade.
While you're here, also try Synchronous Scrolling. This synchronizes your windows scroll bar so you can scroll both of them at once. You must have View Side by Sideenabled for this to work.
This feature isn't exactly groundbreaking, but it is highly useful.
This Tech Tip is brought to you by the Business and Technology Section … IT solutions for today's CPAs. For more information and to view an archive of previous Tech Tips, please visit us here.
Do you have specific topics you would like to see covered in Tech Tips? Email any suggestions to firstname.lastname@example.org.
LAST UPDATED 3/11/2013