Bookmarks in Excel???
 

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

Bookmarks in Excel???
 

Well, if you word extensively, you should know of the find featu 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--

--
RyGuy


"Phil" wrote:

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

Bookmarks in Excel???
 

Phil wrote:
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

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

Hello,

After learning clearly about your question, I think that the method in the following article can help you.
http://www.c-sharpcorner.com/UploadF...tion-in-excel/
It shows how to create a bookmark in Excel.

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.
_________
memory foam mattress | adjustable mattresses | memory pillow