Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a hyperlink within a worksheet
When I use hyperlinks within my worksheets, they always select the cell at
the bottom of the sheet instead of the top left hand corner. Example, if i want to get cell a182 from cell a1, I insert the hyperlink with a182 referenced. When the hyperlink goes to cell a182, it appears selected at the bottom of the sheet, with cell a143 at the top. How can I get a182 to appear at the top of the sheet |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a hyperlink within a worksheet
Just curious, how do you do this. I might be able to help but not sure what
exactly you're entering it. When I enter a182, it tries to open a sheet a182 and returns an error. "pjmflan" wrote: When I use hyperlinks within my worksheets, they always select the cell at the bottom of the sheet instead of the top left hand corner. Example, if i want to get cell a182 from cell a1, I insert the hyperlink with a182 referenced. When the hyperlink goes to cell a182, it appears selected at the bottom of the sheet, with cell a143 at the top. How can I get a182 to appear at the top of the sheet |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a hyperlink within a worksheet
Thanks Mike H,
I create a hyperlink and place it in this document with the reference cell A182 or whatever ceel I want to navigate to. It always opens the link at the bottom of my worksheet. Hope you can help me on this, it's very annoying. Pjmflan "Mike H." wrote: Just curious, how do you do this. I might be able to help but not sure what exactly you're entering it. When I enter a182, it tries to open a sheet a182 and returns an error. "pjmflan" wrote: When I use hyperlinks within my worksheets, they always select the cell at the bottom of the sheet instead of the top left hand corner. Example, if i want to get cell a182 from cell a1, I insert the hyperlink with a182 referenced. When the hyperlink goes to cell a182, it appears selected at the bottom of the sheet, with cell a143 at the top. How can I get a182 to appear at the top of the sheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HYPERLINK Worksheet Function | Excel Worksheet Functions | |||
can I 'hyperlink' within a workbook from the first worksheet? | Excel Worksheet Functions | |||
Is it possible to hyperlink from a worksheet to a chartsheet? | Charts and Charting in Excel | |||
hyperlink a worksheet with no address | Excel Worksheet Functions | |||
hyperlink to another worksheet | Excel Worksheet Functions |