Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to be able to write instructions that list a Table designation and be
able to click on that designation so that I navigate to that table. -- Cliver6 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
In cell A1 type Table1. Press Ctrl+K and create a hyperlink to the top left corner of Table1. If cell X50 contained the title Table1 you could enter =X50 in cell A1 then click on cell A1 and press Ctrl+[ will take you to X50. A more sophisticated way is to wite code to move you to the desired location when you double-click a cell with a table designation. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Cliver6" wrote: I want to be able to write instructions that list a Table designation and be able to click on that designation so that I navigate to that table. -- Cliver6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
Link Cells | Excel Worksheet Functions | |||
How do I link cells in 1 spreadsheet to Specific cells in another | Excel Discussion (Misc queries) | |||
PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS | Excel Discussion (Misc queries) | |||
How do I link a row of cells in wks 1 to update diff cells wks 2 | Excel Worksheet Functions |