Best Microsoft Excel Bloggers

Monday, September 28, 2009

View 2 Sheets in the Same File at the Same Time


Sorry- I guess you could tell that I took a few days off... I was enjoying sun and wonderful weather on the Massachusetts coast.
Here is a picture of Rockport Harbor.. absolutely beautiful..


Today's topic is Viewing 2 Excel Worksheets in the Same File at the Same Time (that's a mouthful isn't it).

Lotus allowed you to do a 3D perspective oh..so many years ago and while Excel does not have a specific command to view 2 or more sheets in the same file at the same time, it can still be done.


The easiest way to view2 or more worksheets at the same time on your computer screen is to open a second window. To do this select the View Tab and then in the Window group, click New Window. It doesn’t look like anything happens when you do this however if you look up at the title bar, you will now see a :2 after the file name to show that a second copy (window) has been made. You can then use each window to display and edit different parts of the same workbook. The files are mirror images of each other and any changes is actually appearing in both at the same time.

I recommend that you close out the window:2 first. If you don't you will end up with a file named :2 which will drive you crazy over time as you can't get rid of the :2.

That's all for today. Have a great week.

No comments:

Post a Comment


Ms. Excel- Resident Excel Geek