• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Directory of headings in worksheet

J

jackmanjls

Member
Is it possible to have a dir of headings in a worksheet?

For instance, I have a single worksht. The worksht is ~2K lines. These lines are broken down into about 40 diff sections. Is it possible to have something like a dir where I can quickly go to a specific section from anywhere in the worksht?
 
Hi ,

When ever you press F5 or the CTRL G ( GoTo combination ) , the dialog box will display all the static named ranges ( those which are not defined as dynamic ranges ) ; what you can do is define named ranges for the headers of each of the 40 sections ; where ever you are in the worksheet , pressing F5 will display the list , and you can click on the name to go there.

Narayan
 
NARAYANK991 said:
Hi ,

When ever you press F5 or the CTRL G ( GoTo combination ) , the dialog box will display all the static named ranges ( those which are not defined as dynamic ranges ) ; what you can do is define named ranges for the headers of each of the 40 sections ; where ever you are in the worksheet , pressing F5 will display the list , and you can click on the name to go there.

Narayan
Click to expand...
That's pretty cool...thanks.
 
You must log in or register to reply here.
Back
Top