Using the FREEZE function in Excel

[paula]

I have a worksheet with 4 rows of introductory data, then
a "header row" that I would like freeze. When I FREEZE
PANES, I know it will include the 4 rows above my actual
header row. Any way to get it to just freeze the one
single row, without deleting or hiding any data? Thanks
for the help!

 

[Guest]

Thanks Camilo - I don't think I worded my question
correctly. Rows 1-3 contain introductory data. My
header row is on Row 4, which is the only row I would
like to move with the scroll. When I freeze the panes
(by selecting Row 5), it freezes Rows 1-4. Any
suggestions on just freezing Row 4? Thanks!

 

[bj]

Set row 4 at the top of the screen Then select a cell in
row 5 and freeze panes.

 

[Gord Dibben]

Paula

All or nothing with Freeze Panes.

Do you need the introductory data in rows 1 through 3?

Perhaps a userform with an introductory message that would pop up when the
workbook is opened?

Users would read the introduction then close the userform.

Would involve VBA coding.

Gord Dibben Excel MVP

 

[paula]

thanks everyone!

-----Original Message-----
Paula

All or nothing with Freeze Panes.

Do you need the introductory data in rows 1 through 3?

Perhaps a userform with an introductory message that would pop up when the
workbook is opened?

Users would read the introduction then close the userform.

Would involve VBA coding.

Gord Dibben Excel MVP



.