View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheikh Saadi Sheikh Saadi is offline
external usenet poster
 
Posts: 27
Default Synchronous scrolling in all sheets of a wokbook.

If you are using Excel 2007, go to View on Ribbon. Find Windows group and
click on View Side By Side. Make sure Synchronous Scrolling is pressed.
Choose you required sheet. Both sheets will be open side by side. This would
do the trick.


In Excel 2003, Click Window -- New Window. Select the sheet you want to
view. Click again on Window menu and choose Compare Sheet Side by Side. Make
sure that Synchronous Scrolling button is click on Compare tool box.

Hope this works for you...

--
Sheikh Saadi


"Oily Rag" wrote:

I have a need to scroll (up and down) in any sheet of a workbook of excel and
then when I switch between sheets in the same workbook - I would like to find
myself in the same place on the new sheet. Is this possible in anyones
experience?