View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gregory[_2_] Gregory[_2_] is offline
external usenet poster
 
Posts: 2
Default Split / Freeze Pane's

Hi Rob,

You keep the cursor on "Cell B2" and than use the freeze pane functions,
should help you

Gregory


"Gaffnr" wrote:

Hi All,
I have a pivot table matrix of data that contains row headers in row 1.
I have the column headers in column A.

Id like to freeze both row 1 and column A as headers so whenever I scroll
accross/down, i can always see my header.

I can use freeze pane to always see header row OR column but not both.

Any ideas?
Rob

--
Rob Gaffney