How to create a directory with excel? Here are five ways!
A dream of Baozheng 2021-02-23 02:24:17

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 .

 How to use Excel Build directory ? There is 5 Methods !


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

 How to use Excel Build directory ? There is 5 Methods !


The following animation shows :

 How to use Excel Build directory ? There is 5 Methods !


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

 How to use Excel Build directory ? There is 5 Methods !


The full animation is as follows :

 How to use Excel Build directory ? There is 5 Methods !


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

 How to use Excel Build directory ? There is 5 Methods !

 How to use Excel Build directory ? There is 5 Methods !


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 :

 How to use Excel Build directory ? There is 5 Methods !


The full animation is shown below :( The demo includes how to modify the file name directly )

 How to use Excel Build directory ? There is 5 Methods !


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 !》

版权声明
本文为[A dream of Baozheng]所创,转载请带上原文链接,感谢
https://fheadline.com/2021/02/20210222225100807P.html
相似文章

2021-08-09