I've found on here that I can shift-select mulitple sheet tabs to allow the cursor to follow it's
position from one sheet to another, but it doesn't scroll the actual sheet.

More explanation, using Excell 2000 (I know, but we don't use it enough to warrant an upgrade). I
have a file with 8 sheets in it all with related data. If I scroll to cell AA:120 on sheet one, I
want all the other sheets to scroll to that cell as well, ALL THE TIME. It seems I have to
shift-select all the sheet tabs first, then scroll, then select the sheet I want to be in, and go
from there. Thing is, beyond having to do the shift-select all the time (which I can live with if I
have to), the other sheets have the cursor moved to the correct cell, but have not scrolled. After
selecting a new sheet tab, I have to hit the arrow keys on the keyboard to "jump-scroll" the sheet
to where the cursor now is.

So, question is, can I make it so that all the sheets are "scroll locked" to each other so that no
matter how I scroll in one sheet (cursor movement, scroll bars, etc) all the other sheets scroll to
the same position, and have the cursor in the same cell, and make this a permanent change for the
file.

I'd also like to lock formatting changes as well, but that's much less important, if I make a cell
bold and 12 point type in one sheet, carry that change to all the other sheets automatically.

Thanks for any input.

Conf.