Hello.
I'm using Excel 2007. I'd like to create a sort-of ever-present, floating note that helps me navigate quickly through my alphabetically organized sheet. The most direct/quickest way I've found to navigate up & down a sheet is via the Name Box. What I'd like to have is a floating note (or user form?) that stays visible despite scrolling through the sheet. I'd like it to show a list of periodic row numbers, say 50, 100, 150, etc., along with the (ever-changing) contents of the corresponding A-Column cells: A50, A100. A150, etc. That way, I can always see the note to know which row to type into the Name Box that will land me closest to the row I want to manipulate, keeping in mind that the names in the A-Column cells will change every time I add a new row and re-alphabetize the sheet.
I hope this is a clear description of what I'd like to do, and I hope some of you Excel gurus can educate me, new excel user, in what seems to be a complicated project.
Thank you.
I'm using Excel 2007. I'd like to create a sort-of ever-present, floating note that helps me navigate quickly through my alphabetically organized sheet. The most direct/quickest way I've found to navigate up & down a sheet is via the Name Box. What I'd like to have is a floating note (or user form?) that stays visible despite scrolling through the sheet. I'd like it to show a list of periodic row numbers, say 50, 100, 150, etc., along with the (ever-changing) contents of the corresponding A-Column cells: A50, A100. A150, etc. That way, I can always see the note to know which row to type into the Name Box that will land me closest to the row I want to manipulate, keeping in mind that the names in the A-Column cells will change every time I add a new row and re-alphabetize the sheet.
I hope this is a clear description of what I'd like to do, and I hope some of you Excel gurus can educate me, new excel user, in what seems to be a complicated project.
Thank you.
