In xl2003 menus:
Window|New window
Window|Arrange
(tiled, horizontal, or whatever you like)
You may want to check windows of active workbook, too.
When you decide that you're done with the multiple windows, you can select the
one you don't want and hit ctrl-w to close it.