How to operate the Excel summary file directory

Select all the files to be copied in the folder, hold down the SHIFT key, be sure to hold down SHIFT, right-click, and click [Copy as Path] in the menu. If it is a Win10 system, you can directly click the file operation option above. Can.

Open Excel and paste in a blank cell, so that all the file paths are put in.

If you only want the file name and do not want the previous path to be displayed, just copy the path, press CTLR H to open the find and replace window, and fill in the search content.

Finally, click Replace All, and all front paths will be deleted. It is very simple.

The above is the detailed content of How to operate the Excel summary file directory. For more information, please follow other related articles on the PHP Chinese website!