How do I view more than one tab at a time, within a given workshee

[Guest]

How do I view more than one tab at a time, within a given worksheet, without
opening copies of that worksheet? Neither splitting the window nor freezing
panes appear to provide this function.

 

[Dave Peterson]

Window|New Window
will create another window into that workbook
Window|Arrange (horizontal/vertical/tiled???)
(and check that windows of active workbook if you want)

(You can select any worksheet in any window--even the same worksheet and view
different locations.)


And when you're tired of this, select a window to close and hit ctrl-w to close
it.

Debra Dalgleish has some instructions with pictures:
http://contextures.com/xlfaqApp.html#TwoWindows

 

[Guest]

Thank you. Two or more fully active windows appear. I can use the mouse to
build formulas across two or more tiled windows.