Ask Experts Questions for FREE Help !
Ask

Excel - Creating a link from on cell/tab to another IN THE SAME FILE

Asked Jan 29, 2008, 04:03 PM — 4 Answers
I am trying to find a way to make a hyperlink in a cell that links to either another cell on the same tab or a cell on another tab WITHIN the same Excel file.

Any ideas?

EDIT: I want a word in one cell that is a hyperlink so that when a user clicks on it, it will JUMP to another cell or another tab in the same Excel file

Just to clarify

Search this Thread
Share |
4 Answers
Marriedguy's Avatar
Marriedguy Posts: 473, Reputation: 590
Full Member
  
#2

Jan 29, 2008, 06:10 PM
Yes..I just figured this one out here what you do.

Excel does have a bookmark feature but Word does.

Open word and type a word, select it. Then Insert, Bookmark , in the dialogue box with open name the bookmark whatever you want and then click add. So that word or item is now a bookmark.

Now create the hyperlink. Type the word(s) and then select it. Right click on it and then select hyperlink from the drop down. Then in the dialogue box click bookmark… select that bookmark you created and ok.

Now just copy and paste them in your cell and thank the geniuses at Microsoft for the great integration features.
Helpful  (1)
ScottGem's Avatar
ScottGem Posts: 57,993, Reputation: 28100
Computer Expert and Renaissance Man
  
#3

Jan 29, 2008, 06:23 PM


Its not necessary to use Word. Basically all you need do, is right click on the cell where you want the hyperlink and select Hyperlink and then follow the instructions from there.
Helpful  (1)
DrJ's Avatar
DrJ Posts: 1,344, Reputation: 1758
Ultra Member
  
#4

Jan 30, 2008, 10:33 AM
Sa-weet! Thanks guys! Didn't think it was possible.

ScottGem... Couldn't rep yeah but it will come back around!

Thanks again!
Helpful
stanleyz's Avatar
stanleyz Posts: 1, Reputation: 10
Junior Member
  
#5

Dec 29, 2011, 06:23 PM
You can do this:

Example tab name: Sales
Syntax: =Sales!A1
This reference tab "Sales" cell A1.
Note tab name cannot not have spaces. Use "_" for space otherwise tab reference don't work.
This works for 2003 Excel.
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



Check out some similar questions!

Who should pickup the tab on first date? [ 9 Answers ]

Recently I try to meet several guys, but I don't know know who should pick up the tabs or half/half? Any opinion will help, thnaks !

Tab options for FF 2.0 [ 6 Answers ]

Just got a new computer and downloaded FF. On my old computer I had NO extensions...and links opened in the same tab by default...which is what I want. Now they open in a new tab, and the only options I have are to open links in a new window or a new tab. How can I get links to open in the...

Excel: Deleted cell content but link is still there [ 3 Answers ]

When I delete text from a cell where the text was a hyperlink, it does go away, but when I go to type new text in the cell, the new text is hyperlinked as the former text was. How can I stop this from happening? Thanks!

Link to a pdf file [ 3 Answers ]

I am asking this question for my brother so bare with me. He wants to allow a user to hit a download button and they can receive a pdf file. I have seen it done just can't remember how the coding is. Is their anything special that has to be done or is this just a link to a pdf form? Any info will...

View more Spreadsheets questions Search