5 Method of Hyperlink to use in Excel 2013 in HINDI│हाइपरलिंक यूज करने के 5 तरीके

What are Hyperlinks? Know quick way to create hyperlinks in Excel

A Hyperlink is a reference to a document, a location or an action that the reader can directly follow by selecting the link. Hyperlinks are used extensively on the Internet and are generally Words highlighted in Underline Blue.

Tips 1: There is another shortcut way also to get Hyperlink. Just Right-click the cell and then click Hyperlink, or you can press Ctrl+K.

Below are the 5 Types of Hyperlinks:
1. Existing File
2. Existing Web Page
3. Place in This Document
4. Create a New Document
5. Send an Email Link

When and Where?
For quick access to related information in another file or on a web page, you can insert a hyperlink in a Microsoft Excel worksheet cell. You can also insert hyperlinks in specific chart elements or images. The use of Hyperlinks in Excel has been extended to a number of areas and this includes:

Opening any type of file
Opening Web Pages on the Internet
Jumping to locations within an existing document
Creating New Documents
Sending Emails

How to Create a Hyperlink to a File:

Step 1: Enter a value under File column with a file name you want to open from your computer. Here we have entered the name “Demo file”.
Step 2: Open Hyperlink and from Insert Hyperlink dialog box click the Current folder and select your file for the hyperlink. Click OK.
Step 3: Your Hyperlink to file created successfully! Now you can open your this file from this excel sheet by a single click on this cell.

Create a Hyperlink to a web page:
Step 1: Insert Hyperlink Dialog box will be opened. Under Link to, click Existing File or Web Page.
Step 2: In the Address box type the web link of Yoda Learning: “https://www.facebook.com/comtutor4u” then click OK.
Your hyperlink is created successfully! Now if you click on that cell it will open that web page in a browser.
Create a Hyperlink to a particular cell of the workbook:

Step 1: create a new sheet and in cell A1 type “Workbook Hyperlink”. We will create a hyperlink in our previous sheet for this new cell of new sheet. Click to a new cell and In the Name box to the left of the formula bar, type the name of the cells, and then press ENTER. Here we type Workbook as a name.
Step 2: Now back to our previous sheet and type under Workbook column “Workbook”. Click on it and open Insert Hyperlink Dialog box as like the previous process.
Step 3: Under Link to click Place in This Document. Select “New” from Cell Reference tree to select our New sheet of the same excel file and select Workbook from Defined Name tree. (Remember we created this Name “Workbook” for the cell “Workbook hyperlink” of New Spreadsheet. To be listed in Defined Name tree you must change the name of that particular cell from Name box). Now click OK.
Our Workbook hyperlink is created. Now when you click on this cell, it will jump to the New sheet’s new cell Workbook hyperlink.

Create a new file using Hyperlink:

Step 1: Type a value under the New File column. Here we typed Word File.
Step 2: Open Hyperlink for this cell. Insert Hyperlink Dialog box will appear. Under Link to, click Create New Document. In the Name of new Document type the name of your new file and select the directory by click Change button. In this example, we are going to create a doc file named “Word File.docx”. Click OK.
Your new file and Hyperlink is created now.

How to Create a hyperlink to an E-mail:

Step 1: Type Send e-mail in a cell under the E-mail column. Open hyperlink for this cell.
Step 2: Under Link to click E-mail Address. Type the email address that you want to use and type the Subject. Click OK.
Your hyperlink to an email address is created successfully! Now you send mail to that particular mail address with a single click on that cell!
ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
https://www.youtube.com/channel/UC2k9JH38F3byw92XaFuoPuw?sub_confirmation=1
फेसबुक पर पसंद करने के लिए क्लिक करें
https://www.facebook.com/Comtutor4u/
ट्विटर पर फॉलो करने के लिए क्लिक करे
https://twitter.com/Comtutor4u

Видео 5 Method of Hyperlink to use in Excel 2013 in HINDI│हाइपरलिंक यूज करने के 5 तरीके канала ComTutor