How to make hyperlinks to multiple files in excel

=HYPERLINK() formula
Links to all the files in a folder and sub-folders.
Use windows command prompt to get a list of file names with their file paths. Use Text to Columns to get the file names on their own.
dir/b/s/o | clip
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:

[baileya]

my jaw literally dropped from the absolute gold this video contained. i honestly didn’t even think something this intricate could be done by without digging up to one’s elbows in code. this video showed me extremely quickly how to do something i thought was too intense to ever manage myself. very crucial to note though that your files must stay in the same place or you’ll break every single link! thank you much for this video!!!

[mr.g]

This is EXACTLY what I wanted to do, explained perfectly! Thank you!

[alialsalihi]

Helpful, precise, timesaving and straightforward. Thank you very much.

[factlogyofficial]

YOU CAN SELECT ALL THE FILES AND HOLD SHIFT AND RIGHT CLICK, THEN SELECT COPY AS PATH AND THEN PASTE IT IN EXCEL :)
SO YOU CAN SKIP THE CMD PART.
THANK YOU

[soulofangel]

holly crap, that's like 20 tips and tricks in one video about hyperlinks, you are just amazing.

[bhanukiran]

This saved many hours of time for me. Thank you so much.

[markozella]

OMG THANK YOU! Exactly what I needed to do. SO MUCH TIME SAVED!

[susanjoyce]

Thank you! Very clear. Could listen to that accent all day! 👍🏻

[acwither]

Very helpful video! Thanks! Learn something new everyday even in excel!

[venky]

Very helpful. Thanks for sharing. Saved a lot of time.

[RavinduMeegasmulla-ybeo]

This is exactly what I wanted. Excellent Video

[luxurylifestyle]

Thank you very much. Following method had saved my time

[kylieb]

I’m gobsmacked it can be this easy….. thankyou !

[srirama]

Thank you this is a really helpfull video

[morguskadarka]

Thank you! Thank you! Now I know the rest of the story.

[senormanana]

great. thx! do you have any idea to make links that do not have full path? I would like to excel sheets with subfolders moveable to another computer with different folders.

[kamilitrading]

Thank you so much for this wonderful video, and If we have files in Drive there's a method like that, Thank you!

[edilbertolopezgonzalez]

Good day, you saved me a lot of time, however, when I copy the folder to another computer or a sent it via email, the links do not work anymore... is there anything I can do to fix it?

[chadtalasek]

When I type in the dir/b/s/o it opens gives me pathways for files outside of the folder I have open

[swamppifi]

you can also select all the files in the folder and right click, then use the copy path option and paste into excel, that how I copy files into excel