Vidakuzi vinatusaidia kutoa huduma zetu. Kwa kutumia huduma zetu, unakubaliana na matumizi yetu ya kuki.
Kidokezo: Lugha zingine ni Google-Ilitafsiriwa. Unaweza kutembelea English toleo la kiungo hiki.
Ingia
x
or
x
x
Daftari
x

or

Haraka orodha ya faili zote na vichwa vya chini vya folder au saraka katika Excel

Watu wengi wanaweza kujiuliza kwa nini hakuna njia moja kwa moja ya kupata na kuunda orodha ya faili za folda maalum au saraka katika Excel. Lakini na Kutools kwa Excel'S Orodha ya Filename matumizi, mafaili yote na vichupo ndogo ya folda maalum au saraka zitaorodheshwa na sifa za faili katika Excel.

Weka majina yote ya faili kutoka kwenye folda kwenye karatasi mpya


Bonyeza Kutools Zaidi > Import / Export > Orodha ya Filename. Angalia skrini:

Futa orodha ya jina la faili 1


Weka majina yote ya faili kutoka kwenye folda kwenye karatasi mpya

1. Fungua kitabu cha kazi ambacho unataka kuunda orodha ya faili kutoka kwenye folda maalum kwenye karatasi mpya, kisha uitumie Orodha ya Filename huduma kwa kubonyeza Kutools Zaidi > Import / Export > Orodha ya Filename.

2. Ndani ya Orodha ya Filename dialog box, kufanya shughuli zifuatazo:

(1.) Bonyeza 123 kifungo chagua saraka ambayo unataka kuandika faili;

(2.) Ikiwa unahitaji kuandika faili kwenye vifungu vidogo au fungua faili zilizofichwa, tafadhali angalia Jumuisha faili kwenye vituo vya chini or Jumuisha faili zilizofichwa na folda chaguo.

(3.) Taja aina ya faili unayotaka kuandika chini ya Aina ya Files sehemu;

(4.) Chagua kitengo cha ukubwa wa faili unataka kuonyesha kutoka Weka kitengo cha ukubwa sehemu.

(5.) Kuchunguza Unda hyperlinks chaguo itaunda hyperlink kwa kila faili iliyoorodheshwa.

orodha ya risasi-filenames2

3. Baada ya kumaliza mipangilio ya hapo juu, bofya OK ili kuunda orodha. Faili zote zilizomo kwenye folda zimeonyeshwa na sifa fulani katika karatasi mpya. Angalia skrini:

orodha ya risasi-filenames3

Tip: Orodha itakuwa na sifa nyingine, kama ukubwa wa faili, aina ya faili, tarehe iliyoundwa na kadhalika.


Zana za Uzalishaji Zilizopendekezwa
Vifaa vifuatavyo vinaweza kuokoa muda na pesa yako, ni moja ambayo ni sawa kwako?
Tabia ya Ofisi: Kutumia vichupo vyema katika Ofisi yako, kama njia ya Chrome, Firefox na New Internet Explorer.
Kutools kwa Excel: Zaidi ya kazi za juu za 300 kwa Excel 2019, 2016, 2013, 2010, 2007 na Ofisi 365.
Menyu ya Classic ya Ofisi: Kurudia menus familiar kwa Ofisi 2007, 2010, 2013, 2016, 2019 na 365, kama ilivyo Ofisi ya 2000 na 2003.

Kutools kwa Excel

Kazi iliyoelezwa hapo juu ni moja tu ya kazi za 300 za Kutools kwa Excel.

Iliyoundwa kwa Excel (Ofisi) 2019, 2016, 2013, 2010, 2007 na Ofisi ya 365. Pakua na kupakua kwa siku za 60.

Screen shot ya Kutools kwa Excel

btn kusoma zaidi Btn shusha ununuzi wa btn

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Asif · 9 months ago
    I am tried . It does import file names however it keeps files names with digit in top and drags with alphabet bottom ?? How can we keep same sequence as in folder?? Thanks
  • To post as a guest, your comment is unpublished.
    kanhaiya · 1 years ago
    how can I get list of folder names only
  • To post as a guest, your comment is unpublished.
    Jeff Williams · 1 years ago
    I am trying to list the files off of my Samsung phone, connected as an external drive, however, it is grayed out for all files on my phone. Will it not work this way? I seem to remember using my external hard drive and doing the same thing. Thanks. Still learning about your product, but it is definitely a time saver.
  • To post as a guest, your comment is unpublished.
    Akshay Jagtap · 1 years ago
    Hi, The tool is just awesome.
    In my Scope, I am Extracting the Video/Audio file names,
    I would like to know if file duration can be extracted too.
    Thanks.
  • To post as a guest, your comment is unpublished.
    max · 1 years ago
    hi

    how can i get only folder lis