First, Ctrl+A selects all files, clicks the copy path button above, and pastes them into an Excel table. Then Ctrl+H replaces the redundant part, pastes the replaced content into the search content, and clicks Replace. Finally, open your Excel file, press Alt+F 1 1 to open the VBA editing window, double-click the worksheet on the left where the name needs to be stored, paste the following code in the space on the right, close the VBA window, press Alt+F8 to open the macro window, select the macro just inserted, and click Execute. In this way, all page signatures will be listed in column A of the form.

Tab refers to the worksheet at the bottom of EXCEL. Open the Excel worksheet and click the+sign at the bottom to add a new worksheet label. Double-click the left mouse button and select Page Signature to change the name of the tab.