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 .

Previous recommendation

《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 ！》