Hyperlink in Excel - (Magical Trick to hyperlinks 1000s of files within seconds)

Поділитися
Вставка
  • Опубліковано 5 бер 2019
  • Hyperlink in excel is used to link different types of files in MS Excel. These files may be in PDF format, photo, audio, video, MS Word file or any other MS Excel file.
    Hyperlink helps to get instant access to multiple files from one location. It can also be used to link any website by using that website address.
    This magical hyperlink trick will help you to link any number of files in excel within seconds. It will help you to save a lot of your time. This is a time saving trick in addition to help you to work like a professional.
    ********** This tutorial will also help you to learn how to export all file names in a folder that is part of this Hyperlink trick.
    Following is link to Tutorial on Hyperlink in Excel (How to use Hyperlink in Excel)
    • Hyperlink in Excel (Co...
    Following is link for Tutorial on How to use Right Function, Left Function, Mid Function, Len Function, Find Function, Concatenate Function (6 Functions in 1 Tutorial)
    • Left, Right, Mid, Len,...
    For further time saving MS Excel and MS Word tricks please visit our channel "Microsoft Office Tutorials" at
    / microsoftofficetutorials
    Also Follow our Facebook Page "Excel Expert" at
    / excelxpert

КОМЕНТАРІ • 98

  • @96seya
    @96seya 3 роки тому +14

    A round of applause for this legend. I'm sure he's saved us countless hours!

  • @earlymorningproductions9355
    @earlymorningproductions9355 4 роки тому +1

    Thank you. It took me a few tries, but this is working now! Very nice, thanks for your efforts.

  • @rogermathura
    @rogermathura 4 роки тому +1

    Excellent, thanks very much. Was exactly what i was looking for to link my IC list to the datasheet pdfs. I just had to make sure the datasheets had same exact name of the IC.

  • @CoreConcepts
    @CoreConcepts 7 місяців тому

    Ultimate info,
    Watching your video after 4 years

  • @manoshikadamunugolla5900
    @manoshikadamunugolla5900 3 роки тому +1

    Thank you so much. It was really helpful. Great work.

  • @metanoya9695
    @metanoya9695 Рік тому +1

    i love the tutorial,, im a basic user,, this helped me a lot, thank you!

  • @wwearmandoma
    @wwearmandoma 3 роки тому +2

    This is a great video. Thank you very much

  • @chaynamodi3756
    @chaynamodi3756 3 місяці тому

    Thank for making such a knowledgeable video as it saves lot of time. Thank you again.

  • @brahimnb-fi8yb
    @brahimnb-fi8yb 6 місяців тому

    Excatly what i was looking for, thanks

  • @zaidahmedgulamrasul2335
    @zaidahmedgulamrasul2335 2 роки тому

    Thank you dude, it's very helpful.... great work

  • @kaganbaydar1050
    @kaganbaydar1050 2 роки тому +1

    Very useful, thank you

  • @thangaveluraj5366
    @thangaveluraj5366 2 роки тому +2

    Excellent!

  • @dianavinasco-duque7911
    @dianavinasco-duque7911 3 роки тому

    Thank you for this tutorial! It is very useful. I just found a problem. I want to do the data validation with the name of my files. They way you show at end of the video. But when I select it to place Source, always pop up a window saying:
    This type of reference cannot be used in a data validation formula.
    Change the reference to single cell, or use the reference with a worksheet function, such as= SUM(A1:E5).
    What do you recommend to do. Or should I make a new column with numbers? Thank you.
    I will appreciate if you can help me!

  • @khalidalmaeeni9980
    @khalidalmaeeni9980 2 роки тому +1

    Thank you 🙏 so helpful

  • @maneeshnarang9091
    @maneeshnarang9091 7 місяців тому

    Really helpful. Thanks a lot

  • @indahreizkia708
    @indahreizkia708 2 роки тому +1

    Thanks for this

  • @Tat-cx1lr
    @Tat-cx1lr 3 роки тому

    Bravo et merci

  • @rashim7637
    @rashim7637 3 роки тому

    Hi
    Is there any option for remain blank or not applicable if no pdf copy

  • @sonalpal9332
    @sonalpal9332 3 роки тому +1

    Thanks bro😁😁

  • @m.sspeckyy7494
    @m.sspeckyy7494 2 роки тому

    How can i do the same thing but linking text in excel list (in your example 11003) to a work sheet in the same document and not to a pdf file?

  • @tutsecret499
    @tutsecret499 Рік тому +1

    What if I want to grab text from each file and place on the current sheet. Example. Let's say all these files destination has 1 row with person name or number and 2nd column has another text or number. I want to the excel copy the row from each file and place on the current. It's like I am colating all the employees in the current sheet(combined staff). So employee 1 would be on row 1, employee 2 would be on row2 and forth. After all is colated. I will have values to count that is on column 2, row 1 or row 2 and so forth. Can you do a video like that. It's just like I am opening each file copying the whole row 1 and pasting on a next workbook.

  • @yenzapanta9696
    @yenzapanta9696 Рік тому

    This is very helpful to me. I was able to create it too perfectly. But, what I need next is to make a copy of this improvised system to other computer. I perfectly understand that I have to change the path file where it will get the files I need. But still it doesn't work with MacBook. Do you have an idea if the path file in Windows OS and MacBook path file can work in excel the same?

  • @leborefilwe5112
    @leborefilwe5112 8 місяців тому

    How will I know if a certain off file is missing , can the hyperlink formula have an exception to return file not found ?

  • @nayazahmedahmed6323
    @nayazahmedahmed6323 4 роки тому +1

    Excellent

  • @xin2yu976
    @xin2yu976 Рік тому

    Thank you so much, what if I want to hyperlink different type of file EG pdf or jpeg with 1 hyperlinks formula? Is it possible?

  • @dineshpatel-sk8rv
    @dineshpatel-sk8rv 3 роки тому

    what if the format of photos are different? like one is jpg other is jpeg how to create hyperlink formulae to open Excat photo

  • @MUHAMMADSALEEM-pc7rh
    @MUHAMMADSALEEM-pc7rh 2 роки тому

    i had apply your define procedure but not success and message receive form MS Excel that requested file could not be found.

  • @MrJack-qu9ej
    @MrJack-qu9ej Рік тому

    Ek excel ka cell refer karna hai different excel mein with the use of hyper link.... So how can we do that

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @didierhardy5231
    @didierhardy5231 5 років тому +2

    Hello, is it possible to have the files to better understand the tutorial? (ZIP format) Thank you

  • @gayanpriyadarshana1326
    @gayanpriyadarshana1326 10 місяців тому

    i have some error message as "Cannot open the specified file" . please help to me.

  • @abdurrahmanjaved4814
    @abdurrahmanjaved4814 4 роки тому +1

    What is the files format has mixed with pdf and jpeg even so i will work? Because you have write pdf in formula

  • @chandrabhansharma3547
    @chandrabhansharma3547 2 роки тому

    Sir excel m kisi word ki file ho hyperlink se attech kiya h Or excel m salary ke total m change kare to jo word hyperlink h us m only salary m hi automatic change kese hoga math or English m

  • @ronprathima
    @ronprathima 2 роки тому

    Hi
    I want these links to be accessible for my team members. But when i share the excel with them it says Cannot open the file

  • @waelsaadwaelsaad6565
    @waelsaadwaelsaad6565 3 роки тому +1

    Dear
    thank you very much this but i am asking can we doing this with multi folders inside it PDF's
    because in my work i need to make hyperlink with multi folders inside each one more that one PDF
    THANK YOU VERY MUCH

  • @Arclight24
    @Arclight24 4 роки тому

    What is the maximum no. Of excel workbooks that can be linked to a master excel workbook? Thanks

    • @sayeed110575
      @sayeed110575 4 роки тому

      Sayeed Shaikh
      1 second ago
      To get scan file name - create batch file. , scan folder you put and click it will create immedite file Name whateter we scan. command
      ECHO OFF
      DIR/B>A.TXT
      EXIT
      ,

  • @jahanzaibshahid9372
    @jahanzaibshahid9372 2 роки тому

    PLZ INFORM HOW TO CHANGE EXCEL SETTING FOR GO TO LINKED CELL DESTINATION BY USING MOUSE SINGLE CLICK INSTEAD OF USING KEY BOARD SHORT CUT CTRL+[ .

  • @abhisheksharma4340
    @abhisheksharma4340 2 роки тому

    Hello, great job i was just looking for this. Can you please tell me if it also possible to use drive (onedrive or Google drive) instead of system folder to do this job ? Anyhow?

    • @abhisheksharma4340
      @abhisheksharma4340 2 роки тому

      An add on named dropspread is available for Google sheets. But i want to do it in excel. Can you help ?

  • @yenzapanta9696
    @yenzapanta9696 Рік тому

    Do you have a video wherein this formula will be made in an excel using MacBook laptop? I badly need to see if it will work the same in Windows OS PC

  • @mr.write1433
    @mr.write1433 2 роки тому

    works only on jpg and pdf ?

  • @abhisheksrivastava64
    @abhisheksrivastava64 4 роки тому

    Hi... I want to send separate cards to 500 persons with their names... I have created Excel Sheet with Name & E-mail... Now I want to prepare attachment link in front of all person... so that i can send mail with the help of Outlook... but I dont know how to create bulk link of attachment... Please help me... It is urgent...

  • @anishkumar6267
    @anishkumar6267 3 роки тому

    How to do this in excel vba userform???

  • @hanisiam7552
    @hanisiam7552 4 роки тому

    Hi , thank you good job , but how i can link excel with folder by hyperlink

    • @sayeed110575
      @sayeed110575 4 роки тому

      Sayeed Shaikh
      1 second ago
      To get scan file name - create batch file. , scan folder you put and click it will create immedite file Name whateter we scan. command
      ECHO OFF
      DIR/B>A.TXT
      EXIT
      ,

  • @Matawfik
    @Matawfik 3 роки тому

    Thank you for this video,
    But why if copy the excel file (with hyperlink functions) + all linked files to another PC , The links do not work

    • @MicrosoftOfficeTutorials
      @MicrosoftOfficeTutorials  3 роки тому +1

      Files path woupd not be the same as it was in old PC. Please check if it is same or no

  • @qutubranalvi203
    @qutubranalvi203 3 роки тому +1

    Very well explained and i already used it

  • @biswajitray5850
    @biswajitray5850 4 роки тому

    how to download diferent list of files from google drive providing such employee id

    • @sayeed110575
      @sayeed110575 4 роки тому

      Sayeed Shaikh
      1 second ago
      To get scan file name - create batch file. , scan folder you put and click it will create immedite file Name whateter we scan. command
      ECHO OFF
      DIR/B>A.TXT
      EXIT
      ,

  • @mohamedshalik8791
    @mohamedshalik8791 4 роки тому

    I tried the same but when I am concatenating drop down list with address it's not changing automatically

    • @sayeed110575
      @sayeed110575 4 роки тому

      Sayeed Shaikh
      1 second ago
      To get scan file name - create batch file. , scan folder you put and click it will create immedite file Name whateter we scan. command
      ECHO OFF
      DIR/B>A.TXT
      EXIT
      ,

  • @naumanfarooq4949
    @naumanfarooq4949 3 роки тому +1

    You are awesome dear.

    • @MicrosoftOfficeTutorials
      @MicrosoftOfficeTutorials  3 роки тому

      Thank you brother

    • @MicrosoftOfficeTutorials
      @MicrosoftOfficeTutorials  3 роки тому

      You may subscribe our this channel too, to learn MS Office in Hindi / Urdu
      UA-cam.Com/UrduHindiLectures

    • @naumanfarooq4949
      @naumanfarooq4949 3 роки тому

      @@MicrosoftOfficeTutorials Please Make a video on having a single sheet taking effect or updates of multiple workbooks automatically.

    • @MicrosoftOfficeTutorials
      @MicrosoftOfficeTutorials  3 роки тому

      Don't understand exactly what you mean

    • @naumanfarooq4949
      @naumanfarooq4949 3 роки тому +2

      @@MicrosoftOfficeTutorials Please Make a video about a workbook in Microsoft Excel getting updated automatically from multiple workbooks.
      Got it ???

  • @marctaggart7222
    @marctaggart7222 4 роки тому

    So why does excel change my link from C:\myfiles to roaming app data roaming appdata roummaing app data users roaming users whatever why on earth cant I put a link in excel and have it stay to the link I put I just can not fathom why this is the way it is !

    • @marctaggart7222
      @marctaggart7222 4 роки тому

      No person knows why. there has to be a way to communicate with excel to tell it HEY DONT CHANGE THIS LINK

  • @ravikiranshirke9288
    @ravikiranshirke9288 Рік тому

    I have done this step but not able to open file while using click here to open

  • @olgamonica3805
    @olgamonica3805 3 роки тому

    I tried but i can't change my hyperlink, it always direct to the same file. Anyone can help me?

  • @cavinbalamurali1130
    @cavinbalamurali1130 2 роки тому

    Another solution is, go to the folder and select all and do right click holding shift key and copy as paths and then paste the paths in a excel sheet. Same results in a sec

    • @ajlaghogho
      @ajlaghogho Рік тому

      Wow! @cavin balamurali Thank you so much for sharing this. This is the simplest approach so far I have seen.

  • @arifulislam2932
    @arifulislam2932 5 місяців тому

    Pleace Share the excel file

  • @kvp1987
    @kvp1987 5 років тому

    How to hyperlink if saved .pdf file name is longer than cell text?

    • @MicrosoftOfficeTutorials
      @MicrosoftOfficeTutorials  5 років тому

      Sorry i don't understand what you mean

    • @MicrosoftOfficeTutorials
      @MicrosoftOfficeTutorials  5 років тому

      Please can you explain a little more??

    • @kvp1987
      @kvp1987 5 років тому

      Microsoft Office Tutorials
      I have files in folder with name 1_filename1_date.pdf, 2_filename2_date.pdf etc...
      in excel column I enter only the filenames as filename1, filename2 etc..
      how to hyperlink filenames to respective files stored in the folder ?

    • @manishlal795
      @manishlal795 4 роки тому

      There are many type of files in one folder say word file, excel file and pdf file and I want to choose only pdf files how should I attach or choose only pdf file in path.
      Suppose I have folder in desktop which file path is this....
      C:/desktop/folder/.Doc, .xls and .Pdf files
      How should I choose only . pdf files
      Please ans.....

    • @farhankhan3994
      @farhankhan3994 4 роки тому

      Sir I'm farhan from Pakistan, I need to creat a excel sheet for vehicle spare parts inventory. I have more than 5000 items in store and issues the items to different vehicles. I want to keep record all data in one sheet. But when I need to check the parts to which vehicle issued , it shows all the details with vehicle no. Plz help me

  • @sayeed110575
    @sayeed110575 4 роки тому

    To get scan file name - create batch file. , scan folder you put and click it will create immedite file Name whateter we scan. command
    ECHO OFF
    DIR/B>A.TXT
    EXIT
    ,

  • @nkowk
    @nkowk 3 роки тому

    Excellent !

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

  • @devhaldar6507
    @devhaldar6507 Рік тому

    Dear Sir,
    Can we use created hyperlink into another system.
    For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.