Hi Everyone,
Here is the Twenty Third Tip for you. Hope this help you.
How the Hyperlink between the sheets helps us.
It means as you click on
the cell, you directly move to that sheet which helps your valuable time. It
helps in making Index, Table etc.
How to Use Hyperlink between
the sheets.
1. Type the text in the
cell
2. Go to the cell in which
you want to get hyperlink with the corresponding sheet
3. Go to INSERT tab, and
select HYPERLINK from there. Or use shortcut (Alt+N+I)
4. From the dialog box Select Place in this
document.
5. Select the Respective
sheet from there.
6. Now the cell is
hyperlink.
7. Click on the same
hyperlinked cell, as you click you will directly go to the that linked sheet.
8. To go back to the
hyperlinked cell, Press “F5” in the Hyperlinked sheet. You will come back to
the hyperlinked cell.
Hope, this tip is clear
with my explanation.
In case of any doubt,
please feel free to contact me any time.
If any of your friends is
also interested for the said excel Tips, then asked them to fill the form by
clicking on the below mentioned link:
Please do share your
valuable feedback. Keep Sharing.
Thanks & Regards,
CA Mohit Bansal
Excel Enthusiast
+91-9045773456
No comments:
Post a Comment