Excel Used to store management data , It's perfectly normal . All kinds of data , monthly ？ By Department ？ By purpose ？...
ok , as time goes on , You'll find more and more worksheets , One document after another ...
that , Find a document some day , Find a table name , Is it a headache ？ Full hard disk to find ？<Ctrl>+F look for ？
If you can make a list of these data , Would that be much more convenient ？
following , I'll share 5 Methods , I hope I can help you ！
Make a table of contents for multiple worksheets in the same workbook
Before making a catalog , Let's first introduce a little technique , That's in the same document , How to quickly find the specified worksheet ？
It's simple , Right click the mouse in the lower left corner , The list of worksheets for the current document appears , such , It's much faster to find .
Get down to business , How to make a directory list for all worksheets in the same workbook ？
Menu selection " data "-" get data "-" From workbook "
Select specific documents
Load data , You can get all the worksheets
The following animation shows ：
Make a directory for documents in the same folder
All documents in the same folder are made in the same way as above .
menu " data "-" get data "-" From the folder "
Select a specific folder
Load the file list
Filter and delete unnecessary files
The full animation is as follows ：
The old version , Create a folder directory with the help of a third-party browser
ok , The old version of children's shoes , With the help of a third-party browser （ System comes with IE No way. , I use it 360） To achieve this function .
In a third-party browser （ An example is 360） Enter the folder address
Copy all the file name information
Paste the Excel in
Filter and delete unnecessary list information
Create a project directory with the help of name manager
Name manager Files The formula , You can get the list of file names in the specified directory .
The formula ： =Files( Folder )
then , Use it in a cell Index Formula to get the specific file name of this list .
As shown below ：
The full animation is shown below ：（ The demo includes how to modify the file name directly ）
Hyperlink Add jump links to cells
usage ： =Hyperlink( Specific address , Link display content )
This usage is not difficult , Animation demonstration can refer to the above animation .
《300 individual Excel Function formula description , You can use it , There are... Here ！》
《 stay Excel Check the form √ Of 7 Methods , Which one do you like to use ？》
《Excel in , Those can instantly improve efficiency , But they don't use many skills ！》