General discussion

Locked

Excel display 2 sheets side by side

By rquisenb ·
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.

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by saihib In reply to Excel display 2 sheets si ...

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

Collapse -

by rquisenb In reply to

But this doesn't help if I want to keep both sheets in the same workbook.

Collapse -

by zimonar In reply to Excel display 2 sheets si ...

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.

Collapse -

by rquisenb In reply to

But this doesn't help if I want to keep both sheets in the same workbook.

Collapse -

by Nilt In reply to Excel display 2 sheets si ...

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.

Collapse -

by rquisenb In reply to

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".

Collapse -

by rquisenb In reply to Excel display 2 sheets si ...

This question was closed by the author

Collapse -

Solution

by procyon5 In reply to Excel display 2 sheets si ...

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...

Back to Software Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums