MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Freezing Top Row

Posted by Phil on January 16, 2001 6:19 AM

I have a sheet with columns of data, each column has a text header.

Is it possible to just freeze the top row of headers when scrolling?. I tried the freeze pane setting but it limits what data can be viewed due to screen size.

Posted by Mark W. on January 16, 2001 6:31 AM

1. Unfreeze any existing panes
2. Select cell A2
3. Re-freeze panes