EXCEL TIPS | How to display the file path and name in Excel?

preview_player
Показать описание
How to display the file path and name in Excel?

In this video I'm going to show you how to insert the path and file name in your Excel spreadsheet.

Here is the method step by step:

- Click to select the cell of your choice.
- Type in the following command in the formula bar or in the cell:
=cell("filename")
- press Enter.

This function returns the full path and file name of the active sheet.

___

This channel provides resources for students, engineers, technical professionals, applicable to other professional who uses a computer! :D

Find every week new tips, tricks and in depth tutorials!

It's focused on Excel and Microsoft Office for the moment but I will create soon tutorials for AutoCAD and other engineering software (Autodesk Robot Structural Analysis, LUSAS), parametric and computational design with Rhino and Grasshopper.

Certainly some engineering lessons and we might do a bit of coding/programming as well ;)

Hope you'll enjoy!

Leave in comments any suggestions for future videos, topic that you'd like me to explain, etc... I'll do my best to answer your questions! :)

___

Follow me here:

And soon on other platforms!
Рекомендации по теме