Problem with viewing 2 sheets within the same Excel workbook using dual monitors

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin - 05 Feb 2008 15:35 GMT

I am able to get Excel to display 2 different sheets within the same
workbook (one sheet on each screen). However, when I page up or down
on one sheet, the other sheet also moves. Does anyone know how to
lock down one of the sheets? When you're trying to look at formulas
and figure out how they link from one sheet to another, it makes it
very difficult when both sheets move.

Reply to this Message

Max - 06 Feb 2008 08:19 GMT

Don't use the "Compare side by side with" feature
Just use Window > Arrange, tile it to suit

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>I am able to get Excel to display 2 different sheets within the same
> workbook (one sheet on each screen). However, when I page up or down
> on one sheet, the other sheet also moves. Does anyone know how to
> lock down one of the sheets? When you're trying to look at formulas
> and figure out how they link from one sheet to another, it makes it
> very difficult when both sheets move.

Reply to this Message