Freezing Panes

Closed
Report
Posts
48
Registration date
Saturday October 27, 2012
Status
Member
Last seen
March 4, 2014
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
Hello friends,

I want to freeze more than one row (like 5, 8, 20, etc) and column (like E, K, O, etc) at random location at the same time in excel.

Can it be possible?

If yes, pls suggest me or if not pls suggest, may I do it using Macro?

Pls suggest

Regards

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Ugn10,

I can't even imagine how that would work.
How do you visualize this for yourself? Like Row 5 at the top, row 8 in the middle and row 20 at the bottom?

The best thing I can come up with is to group or hide rows 1-4 and 9-19 and then freeze row 20.

If you are not satified (and I don't blame you) then please explain the functionality of your idea.

Best regards,
Trowa
0