Split / Freeze Pane's
 

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

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

Split / Freeze Pane's
 

Thanks Ryan - you are the man. All these years of using excel and i never
knew that. Im laughing out loud at my stupidity.
Thanks very much, appreciated
--
Rob Gaffney


"ryguy7272" wrote:

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

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