Can I freeze a column and have it not scroll vertically?

I'd like to keep a sort of "menu" of links in the first column of a spreadsheet of mine that is some 600+ rows long... it's my lip balm formula page that has all the measurements and calculations for my homemade lip balms that I sell. The links go to each "recipe" within the sheet, and I want to be able to click them from wherever I am in the sheet. The obvious choice would be to put them in the first row and freeze that, but a) there are too many links and b) the column widths are quite varied... also it's not nearly as "expandable" as doing a column would be--as I add new sections and link to them it's much easier and tidier to make a link in a new row in Column A than to make another cell in Row 1.

Currently my "menu" is taking up the top 4 rows, but as I expand and add more lip balm formulas, I have to either make my menu wider (not really a good option--horizontal scrolling is a nuisance) or add more rows... the problem with that is that the links don't adjust when I add a new row--all of the recipes are pushed down a row, so for example my "Just Gone Nuts" lip balm recipe was at A413 but when I added the new menu row it moved to A414... but the link to that recipe still goes to A413.... so each time I add a new row I have to update *all* the hyperlinks... yeauck!

But if I freeze the first column and put the links there, as I scroll down the page I scroll past my menu. Is there a way to "fix" a column so that it remains TRULY frozen? No scrolling in either direction? I suppose my kind of lame fall-back is to have a "back to top" link after each recipe section so that I can quickly get back to my menu...

(I hope that made sense)

Thanks,
Kat

I'll look into the range thing... don't know much about that. I already have a menu on another sheet and it never gets used--this is real "in the moment" instant kind of navigation that I'm doing when I'm working in the spreadsheet. Back and forth and from here to there and then off again... changing to another sheet just to click a link slows me down enough that I don't bother with it, as I've learned from experience, having tried it. Thanks though.

Anyone want to give the 3-minute overview of what a "range" is?

Hi,

Have you tried using freezing after your first top 4 rows by selecting cell B5?

Would be good if you can share excel with dummy data in it.

Shekhar Sharma

Ok, but how do I create a hyperlink to a range? I don't need to reference it (like =SUM) I just need to be able to jump my cursor to it by clicking a link.

Originally Posted by FDibbins

AFTER you have created the range names that you need....

in 2007, go to insert, hyperling, select "place in this document", click on the range name you want, click ok and you'r done

Oh. My. God. This is the most useful thing ever! You should see me--I've been on a range/cell naming spree and then either doing =[name of range/cell] or linking to them like a mad woman! This will really help me a lot--thanks for the tip!