In 1-2-3 you used to be able to force two windows viewing the same sheet but
widely different rows to keep their viewed columns oin step. This facility
still exists at least in Excel 2003 as an inherited relic from an imported
file, but I cannot find out how to set it up in a new spreadsheet. The two
synchronized windows can have independent excel-style splits allowing
further different ranges of rows to be viewed.