0

Though this question I found how to freeze a pane so it freezes the first row and column.

Freezing Row 1 and Column A at the same time

I am looking to now know is there a way to freeze a "square" in excel? So cells surrounding A2:O12 are frozen? I know this is an odd request, but there is a reason for my madness. Which is I have users that find ways of doing the craziest things.

Community
  • 1
  • 1
Matt Ridge
  • 3,633
  • 16
  • 45
  • 63

1 Answers1

0

Solved it, instead of using the freeze pane the way it was in the other link, I selected one square wider and longer than what was required and clicked on the freeze frame, it trapped the cells exactly the way I wanted it to.

In English, the row 13, and column P were selected, I clicked on freeze frame, and it worked.

Matt Ridge
  • 3,633
  • 16
  • 45
  • 63