How can i keep "columb A" still at all times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
Cannot be done without also freezing the rows above your range of hyperlinks in
Column A

How about a workaround?

Window>New Window

Window>Arrange>Vertical.

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
 
Cannot be done without also freezing the rows above your range of hyperlinks in
Column A

How about a workaround?

Window>New Window

Window>Arrange>Vertical.

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



- Show quoted text -
Click to expand...

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,
 
Back
Top