View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mary Ann Mary Ann is offline
external usenet poster
 
Posts: 31
Default Scroll all sheets to same row

I have a spreadsheet with say 10 worksheets in it. Each worksheet is laid
out the same way.

I regularly need to scroll to the same place in each sheet, lets say row
100. Is there a way for me to scroll to row 100 on the first sheet I look at
and then when I go to the next sheet, it is already showing row 100 on screen
so I dont have to scroll again on each sheet.