I am naming cells so they will be easier to find via a drop-down menu. I have
the cell which is the title of one of 85 sites I need to look at from time to
time. I place the title of the site on the top left area of the workbook, and
then select it, go to insert/define/add the name of the site. When I try to
go to this site it comes up on the very bottom of the viewable cells on the
page. I would rather it come up on the top where I first selected the name
when I added it. Now that I have all 85 titles in the naming dropdown, is
there an easy way to make then appear on the top of the page so I don't have
to scroll to see the contents of the site.
Thank you in advance.