Excel tab as windows

[Guest]

Is there a way while running Excel to be working on one tab and open another tab as a smaller window that is always on top. So I can enter information in both tabs without having to minimize, maximize, or switch back & forth?
Thanks
C. Fillmore

 

[Frank Kabel]

Hi
you could align the windows so you can see both at the same time. But a
'always on top' option does not exist AFAIK

 

[Dave Peterson]

But you could do
Window|new Window
then
Window|arrange|tiled
(resize manually)

When you're tired of this, click on the window you want to close and hit ctrl-F4
(or ctrl-W).

Excel will try to help you by showing a number in the title bar:
book1.xls:1 or book1.xls:2

They're not separate workbooks--just multiple windows to the same workbook.