View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_643_] Rick Rothstein \(MVP - VB\)[_643_] is offline
external usenet poster
 
Posts: 1
Default Freeze /Split frames

Am I doing something wrong? My XL2003 will only freeze or split, but not
both at the same time (the small gray box disappears when I elect to freeze
the rows).

Rick


"Reitanos" wrote in message
...
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