Making a column static

T

Todd

Is there a way to make a column static, so it's always
displayed?

I have a spreadsheet that I've created hyperlinks in
column A, which take you to various sections of the
worksheet. I then have the header row frozen.
Unfortunately when I scroll down, my hyperlinks in column
a disappear. I need them to be visible at all times.

Any suggestions? Unfortunately I'm still using Excel 97.

Thanks.
 
P

Peter Atherton

Todd

With Office200 it's windows SPlit with 97 I think it was
Windows FreezePanes

Regards
Peter
 
C

Chip Pearson

Peter,

Split Window and Freeze Panes are very different things. Both
Split and Freeze are available in all versions since 97.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
T

Todd

Peter & Don,

Thanks for the help. Actually Excel 97 has both Freeze
and Split functions. I messed around with split, but it
didn't work for what I needed.

Unfortunately, the unfreeze, freeze option doesn't work
either. The freeze in b2 partially works. It will freeze
the column when I scroll across the worksheet. But when I
scroll down my hyperlinks disapper in the row that's
frozen.

I may not be able to do what I'm trying.

Todd
 
D

Dave Peterson

do you have hyperlinks on each row?

Or do you just have a few hyperlinks (say a1:a10) that you always want to be
visible?

FreezePanes should allow you to see the hyperlink for any visible row.

If you only have a few and want them to always be visible, how about putting
them in Row 2 (and 3???) and then freeze panes under that.

Maybe putting them in Row 1/2 with headers in row 3 would look prettier.
 
D

Dave Peterson

You may want to experiment with some objects from the drawing toolbar
(pictures/shapes). You can right click on them and assign a hyperlink.
 
Top