Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
bookmark or hyperlink?
Is there a way to create a "button" in a worksheet that will take you to a specific place somewere else in a worksheet? As a way to not have to scroll through a large workbook. -- swissforestry ------------------------------------------------------------------------ swissforestry's Profile: http://www.excelforum.com/member.php...o&userid=28719 View this thread: http://www.excelforum.com/showthread...hreadid=515388 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
bookmark or hyperlink?
You can name the cell by clicking INSERT on the menu and selecting NAME,
DEFINE. After the name has been defined you can press the F5 GoTo key, which will display a list of named cells in the workbook. You can either select the name from the list of displayed names or type the name yourself in the REFERENCE field. Click OK and you're there. -- Kevin Backmann "swissforestry" wrote: Is there a way to create a "button" in a worksheet that will take you to a specific place somewere else in a worksheet? As a way to not have to scroll through a large workbook. -- swissforestry ------------------------------------------------------------------------ swissforestry's Profile: http://www.excelforum.com/member.php...o&userid=28719 View this thread: http://www.excelforum.com/showthread...hreadid=515388 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
bookmark or hyperlink?
Create a button on the worksheet and assign the following macro
to it: Sub GotoRange() Application.Goto Worksheet("Sheet2").Range("A2"),True End Sub change the range as desired. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "swissforestry" wrote in message news:swissforestry.23n3cn_1140626410.038@excelforu m-nospam.com... Is there a way to create a "button" in a worksheet that will take you to a specific place somewere else in a worksheet? As a way to not have to scroll through a large workbook. -- swissforestry ------------------------------------------------------------------------ swissforestry's Profile: http://www.excelforum.com/member.php...o&userid=28719 View this thread: http://www.excelforum.com/showthread...hreadid=515388 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink won't open any other XLS file | Excel Discussion (Misc queries) | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
hyperlink in excel to a bookmark in a pdf | Excel Discussion (Misc queries) | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
Removing hyperlink | Excel Discussion (Misc queries) |