View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Reitanos Reitanos is offline
external usenet poster
 
Posts: 123
Default Freeze /Split frames

The title of your post has the answer to your question:
1) Use Window/Freeze Panes command after selecting cell A3 to get the
3 rows at the top to remain when scrolling
2) Use the Split feature (accessed by the small gray box above the
vertical scroll bar or Windows/Split) to split your total row into a
separate pane that will scroll independently


On Jun 9, 5:08 pm, Thor wrote:
I'm working on a Excel 2003 sheet. I want the three row column titles to stay
at the top as you scroll down the page AND I want the total row, a couple of
hundred rows below to always show when scrolling, This means that the title
rows and total row is always seen when scrolling.
--
Thanks