John
You set up a new window. Window>New Window. You will get a :1 or :2 after
the file name (top left), now go to Window>Arrange... and select the format
you want from the dialog.
You now have two 'views' of the same file and can have one window on one
sheet and one on another.
When you have finished you can click on the close cross at the top of one
window, maximise the other and save. If you save as-is, it will re-open
with the two windows showing
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
