Home >Software Tutorial >Office Software >How to create a file access path in Excel_A few steps to solve the problem of too many files

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

WBOY
WBOYOriginal
2024-06-05 11:01:04274browse

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.

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

#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.

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

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

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

#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.

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

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")

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn