 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
- First, insert your picture of an Apple.
- Right-click the Apple and select Hyperlink
- On the left panel, click on Place in Document
- Enter the Cell target in "Type in the cell reference"
- Double-click on Sheet2 in the "place in document" listing
- Your Hyperlink is created
- Deselect the apple
- Click on the apple
- You will go to Sheet2 to the cell indicated
|
||||
|
How to go to another sheet?
I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because I want to send to others.
Example: if I click on Apple from Sheet 1, I will go to Sheet2 |
||||
|
||||
|
Don't misunderstand HYPERLINKS, they are not only values to destination outside the sheet. HYPERLINKS can connect to positions within one workbook, too, which sounds like what you want. This behavior will be consistent to others to whom you send this sheet. This is an 'internal" hyperlink. |
||||
| Question Tools | Search this Question |
Add your answer here.
Check out some similar questions!
How to connect one excel sheet to other excel sheet.
I have attach what I have done on the site. What I need to do is link all of the data from sheet one to sheet 2. All I have found so far is how to link one cell to the other cell. In sheet 1 I have af 3 to af 699 . I need to bring all that data to sheet 2 to (d3 to d24) Sheet 2 will link into...
Connest two sheets like I have counts in sheet 1 and want total in sheet 2 .
Please answer this when told to go make a entry on the balance sheet how do I do this?
Is there a way to create a master list of names in one sheet so that when you add or delete rows or columns in the masterlist the other sheets that use this masterlist will automatically add or delete the changes? How would I copy this list. I tried to link it as a formula but that didn't...
View more questions Search
|
