View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rob merritt rob merritt is offline
external usenet poster
 
Posts: 4
Default split window stop scroll in bottom ?

hi

I have a work sheet split in half
the bottom half is used to keep a list of replacement
caretakers who cover for ones on holiday,
the top has the assigments
ie
jim covers for ted at theis site


how can I make it so the top and bottom
cant scroll in the same space

ie top scrolls from row 1-500
bottom scrolls row 500-1000