View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Split / Freeze Pane's

Hello Rob! As far as I know, freezing the window for a Pivot Table is the
same as freezing a row for anything else in Excel. Go one cell below, and
one cell to the right, of where you want the view frozen. Click on this cell
so it becomes the active cell, then click Window Freeze Panes. I think
that will give you what you want. If not, post back.

Regards,
Ryan--

--
RyGuy


"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