Using the FREEZE function in Excel

P

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!
 
G

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!
 
G

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
 
P

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



.
Click to expand...
 
Top