How to create a file access path in Excel_A few steps to solve the problem of too many files

How to make the file access path? If you have many files to manage, long file paths can cause you a headache. PHP editor Zimo will teach you step by step how to create an Excel file access path to help you easily solve the problem of too many files.

1. First, we create a new Excel table and click [Data] - [New Query] - [From File] - [From Folder] above. Then select your folder.

#2. After selecting the folder, click OK. The name and other information in the folder will be automatically imported into Excel. After confirmation, click Load.

#3. Then all the file information in the folder will be displayed in the Excel table.

#4. Then we select the file address column and name column, right-click [Delete other columns], so that there are only file names and corresponding addresses in the table. Finally click Close and Upload so that the entire directory is much clearer.

5. What you need to do next is to create a list of files that are quickly set to be opened, and enter the code =HYPERLINK([@[Folder Path]]&[ in the rightmost list @Name],"Open folder")

In this way, all directory operations are done. If you want to find and open a file in the future, you can directly open it in the Excel table. You can quickly set and run files, and the directory can be automatically updated, which is very convenient. Come and try it, friends.

The above is the detailed content of How to create a file access path in Excel_A few steps to solve the problem of too many files. For more information, please follow other related articles on the PHP Chinese website!