Freezing Panes

Closed
ugn10 Posts 48 Registration date Saturday October 27, 2012 Status Member Last seen March 4, 2014 - Jun 19, 2013 at 08:49 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 20, 2013 at 10:59 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 20, 2013 at 10:59 AM
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