Excel 2013 Allows Viewing Spreadsheets Side-by-Side in Separate Windows

Printer Friendly
Text Size: A A A A

http://www.groovypost.com

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!

Image: Tech Tip - March 11, 2013

Image: Tech Tip - March 11, 2013

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.

Image: Tech Tip - March 11, 2013

By default, this will arrange your windows horizontally.

Image: Tech Tip - March 11, 2013

You may want to collapse the ribbon (CTRL + F1) to get a little bit more viewing space.

Image: Tech Tip - March 11, 2013

To arrange the windows differently, click Arrange All.

Image: Tech Tip - March 11, 2013

This will give you a few different options: Tiled, Horizontal, Vertical and Cascade.

Image: Tech Tip - March 11, 2013

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.

Image: Tech Tip - March 11, 2013

Conclusion

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 communications@ficpa.org.

LAST UPDATED 3/11/2013