Bookmarks in Excel???

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

I am new to Excel programming, but am very familiar with Word. In Word, you
can search for a particular location in a document using the Bookmark
function. Is there a similar option in Excel? If so, how do you create it
and search for it.

Thanks,

Phil
 
Well, if you word extensively, you should know of the find feature: Ctrl+F.
Also, there is a neat way of getting to any specific cell: Ctrl+G, then
enter the cell reference, such as J10, or whatever you need. Another useful
trick is to insert a hyperlink: Insert > Hyperlink, Place in This Cocument
(or choose another type of link), and enter the cell reference, such as J10.
In terms of a 'bookmark' I don't know of any such thing for Excel.

Regards,
Ryan--
 
Phil said:
I am new to Excel programming, but am very familiar with Word. In Word, you
can search for a particular location in a document using the Bookmark
function. Is there a similar option in Excel? If so, how do you create it
and search for it.

Thanks,

Phil
Click to expand...

I've used hyperlinks, especially for locations on other worksheets in
the same workbook, and I've used single cell range names.
(Insert/Names/Define). The range naming thing gives you a selection in
the "Name Box" as well as in the "Go To" dialog box.

As far as accessing from outside the spreadsheet, I think there's a way,
but I forget what it was.

Beege
 
Back
Top