Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 471
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HYPERLINK Worksheet Function David Messenger Excel Worksheet Functions 3 October 11th 07 08:55 PM
can I 'hyperlink' within a workbook from the first worksheet? LavenderBush Excel Worksheet Functions 7 August 5th 07 04:37 PM
Is it possible to hyperlink from a worksheet to a chartsheet? kippers Charts and Charting in Excel 1 January 16th 07 12:15 PM
hyperlink a worksheet with no address Jared Excel Worksheet Functions 2 August 14th 06 02:16 PM
hyperlink to another worksheet billy boy Excel Worksheet Functions 2 November 25th 05 01:10 PM


All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"