Hyperlink in Excel
Hyperlinks are very useful for quickly retrieving information from a file / website related to a current file while working in Excel. You can also generate link to specific elements like photos, charts etc. you can copy or edit the link. you can also delete the link easily.
Create link to a new File.
This Option is use to link a new file with your current file.
STEPS :
Select Cell ( where you want to create a link.)
Go to Insert tab
Click Hyperlink (Ctrl+K)
Click Creat new Document
In the Name of new Document box, type a name of the new file
In the when to edit – select (1) Edit the new document letter or (2) edit the new document now
In the Text to Display box, type the text that you want to represent your link
8. Click on Scre...