View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Duane
 
Posts: n/a
Default Navigating in Excel sheets

I have several worksheets which are the same layout, with different
information, all related. I would like to move around in one sheet, and when
i go to another sheet, have the same position displayed. I do not want any
changes I make to a cell on one sheet to hard enter on the other sheet, so
highlighting all the tabs is not an option.

I would like that when I go to another sheet, the same cell is in the window
to see the effects, rather than scroll around to find it.