Previous Topic Next Topic

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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

How can I fix Hotmail if it keeps freezing or crashing?
joshitha007 -
blackmafia -

2 responses
Acer laptop freezes on start up
Kezza -
Taf -

20 responses
The Sims 3 Not responding
Willy -
sims3fanatic -

170 responses
my ps3 original model keeps freezing at startup
Chrisyrhefishy -
dannyds -

1 response
Computer keeps freezing after a few minutes after startup
Mephisto14 -
reubz -

5 responses