Freeze Top Two Rows

[ShawnExcel]

I can't believe that I cannot freeze the top two rows, but with both VBA and the freeze rows button, I cannot get the top two rows to freeze. Every time I do, it freezes the top 6 rows, and also freezes some columns. I only want the top two rows to be frozen. Any ideas?

Thanks!

 

[NARAYANK991]

Hi ,

Are there any merged cells in the top 6 rows / left-most columns ?

Narayan

 

[ShawnExcel]

There are no merged cells in any of the affected areas. It is a spreadsheet with a table. The table starts at Row 6, but above it are just normal cells.

 

[NARAYANK991]

Hi ,

I have tried it without any problem. Can you upload your workbook with just the table layout ? If you want you can clear the table of data.

Narayan

 

[ShawnExcel]

I look forward to your response. Just looking at getting the top two rows to always be at the top. I am also looking for Macro code so someone can hit a button and it locks the top two rows at the top.

Thank you so much,
Shawn

 

[NARAYANK991]

Hi Shawn ,

It seems to be working without any problem.

I have edited your post , removing the access password , and the file.

Narayan

 

[NoSparks]

Works for me. Select A3 and freeze panes.

 

[ShawnExcel]

Woah yeah it works when I exported that sheet. Let me look at the differences and I will let you know. Thanks for looking into it