Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks w/bookmarks copied from Excel 07--HELP | Excel Discussion (Misc queries) | |||
Bookmarks and exporting data into Excel | Excel Discussion (Misc queries) | |||
Bookmarks on Sheet | Excel Discussion (Misc queries) | |||
hyperlinks to bookmarks in pdf files | Excel Discussion (Misc queries) | |||
Creating Excel bookmarks | Excel Worksheet Functions |