Software

Ask something
Discussion Locked

Excel display 2 sheets side by side

0 helpful
8 replies

by rquisenb

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In Excel, how can I display two sheets of the same workbook side-by-side. I would like to "jump back and forth" editing the two sheets.

8 replies

by saihib

Save your workbook with a different file name and then open 2 instances of Excel. Tile your windows vertically.

by zimonar

Save each sheet alone:
- Activate the first sheet tab and click on File from the Menu bar, Save As?, in the File name box, type Sheet1 and click on Save.
- Activate the second sheet tab and follow the steps above. In the File name box, type Sheet2 and click on Save.
- Open the two workbooks Sheet1 and Sheet2; select the first one from the Task bar and click on Window from the Menu bar, click Arrange?, check the Tiled box or Horizontal box and click OK.
- To continue your work later, click on File, Save Workspace?, type a name in the File name box and click OK.

by nilt

There's no easy way to answer this. I don't think there's a way to do what you want and keep them in the same file at the same time. Is it critical to keep them within the same file? You could always copy/paste back and forth if need be but that's a bit kludgy.

A little more detail may help someone assist you. If not, try at the Microsoft Excel newsgroup:
http://tinyurl.com/rep2z

There are folks there as well who may be able to assist you.

by rquisenb

Thank you. I may try the MS Excel newsgroup, but I'll assume that you have given me a definitive answer. Seem's like most of the MS Office questions that I have posted (Word, Excel) have concluded "can't do it".

by procyon5

Just did this in Excel 2003. Click Window,New Window. This will show two copies of the same workbook. Then you can use Window, Arrange to arrange them vertically, horizontall, tiled, etc...

This discussion is closed to new replies.