Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display hyperlinked cell on top of screen

Status
Not open for further replies.
jj22171

jj22171

MIS
Jun 22, 2007
39
0
0
CA
My spreadsheet has hyperlink that points to say, cell A50. When selected, it goes to A50 but at the bottom of the screen. How can I make it display as the first cell on the top right of the screen? Thanks for the help.
 
Sort by date Sort by votes
hi,

Scroll so that A50 is where you want it.

Notice the last displayed cell in column A.

Change the hyperlink to THAT cell.

Skip,
[sup][glasses]Don't let the Diatribe...
talk you to death![tongue][/sup][sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Set Cell Equal to Selected Value from Dropdown.
Replies
2
Views
117
combo
combo
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
170
ladyck3
ladyck3
Cpreston
  • Locked
  • Question
If cell is blank use data from another cell 1
Replies
10
Views
149
Andrzejek
Andrzejek
Erniego
  • Locked
  • Question
Cannot autofit for mirrored cell
Replies
2
Views
105
Cole Mendoza
Cole Mendoza
Cpreston
  • Locked
  • Question
Add characters to a cell Excell 1
Replies
4
Views
130
Cpreston
Cpreston

Part and Inventory Search

Sponsor

Back
Top