ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Bookmarks in Excel??? (https://www.excelbanter.com/excel-programming/407235-bookmarks-excel.html)

Phil

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

Jim Rech[_2_]

Bookmarks in Excel???
 
To ease navigating you can name a cell or range using Ctrl-F3 and then
return to it using F5.

--
Jim
"Phil" wrote in message
...
|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



Jim Thomlinson

Bookmarks in Excel???
 
There aren't really anything analagous to bookmarks. What you could use would
be named ranges. Create the named range by selecting the cell or cells that
you want to navigate to and in the Address Box change the address to some
name. Now when you want to go to that area just select the name from the
address drop down...
--
HTH...

Jim Thomlinson


"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



All times are GMT +1. The time now is 10:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com