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.

Well you should be able to put your cursor just under your last link in
Column A and then freeze panes. You should then be able to scroll up and
down and the the links will always be there, of course this will freeze all
columns, not just column A.

"K M Snowdon" 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.

The first point to look for help is in Excel help.

You know that if you click on row 2 and freeze panes it will freeze row 1.
Well, similarly if you click on column B and freeze panes it will freeze
column A.
If you click on cell C3 and freeze panes, it will freeze rows 1 & 2 and
columns A and B, in other words it will freeze everything above and to the
left of the selected cell.
--
David Biddulph

"K M Snowdon" <K M wrote in message
...
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.

Reading the original message again, if freezing rows & columns doesn't do
what you're after, try generating a new window and arranging the two windows
so that one window remains fixed and visible while the other one scrolls.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
The first point to look for help is in Excel help.

You know that if you click on row 2 and freeze panes it will freeze row 1.
Well, similarly if you click on column B and freeze panes it will freeze
column A.
If you click on cell C3 and freeze panes, it will freeze rows 1 & 2 and
columns A and B, in other words it will freeze everything above and to the
left of the selected cell.
--
David Biddulph

"K M Snowdon" <K M wrote in message
...
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.

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.

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,