Pages

Sunday, February 3, 2013

Tip: Working with 2 Excel Files / Worksheets Side by Side


Good day. A tip for people who work a lot with Excel: If you want to work with 2 files/ 2 sheets at the same time, its much easier if you can have them side by side. A combination of Office 2007 and Windows 7 ( which is very popular in a lot of companies ) won't let you do that.

A way to get that to work:
1- Open one file normally, resize it to take one side of the screen by pushing Windows Key + Right Arrow.
2- Go to start > All programs > Microsoft Excel > File > Open and open the second file that you want to work with (or the same file and open a different worksheet if you want to see two sheets from the same file at the same time). When the file is open, push Windows Key + Left Arrow.

Voila.

No comments:

Post a Comment