On Oct 2, 10:07 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Cannot be done without also freezing the rows above your range of hyperlinks in
Column A

How about a workaround?

WindowNew Window

WindowArrangeVertical.

Re-size window1 to just column A and re-size window2 to fit the rest of the
screen.

Column A will not scroll when using window2

There may be other workarounds.

Where do the hyperlinks point to?

Gord Dibben MS Excel MVP

On Tue, 2 Oct 2007 13:15:03 -0700, K M Snowdon <K M



wrote:
I have created some hyperlinks in columb A, and i would like them to remain
in veiw when i scrolll DOWN the sheet, Normal freezing only works when i
scroll ACROSS the sheet, and not downwards. Imagine just like a web page
really. HELP WOULD BE MUCH APPRECIATED, THANKS KEV.- Hide quoted text -

- Show quoted text -

Thanks very much for your help, and it works !!. The links point to
another part of the same document, or another tab in the same doc, if
you know another way, i would greatly appreciate your help. I'am going
to email the file so i'am not sure if the two windows will be the best
option, although they are the best upto now.
Many Thanks Kev,