Senin, 02 November 2020

Copy File Names From Windows Explorer and Paste into Microsoft Excel

Halo SABIT (Sobat Rabbit) karena Mobit (mommy Rabbit) juga kerjaannya ngurusin excel n java sekalian aja ya kasih tips disini sedikit tentang exceL. 

kali ini cara copy file name yang ada di windows explorer ke excel. jadi misal SABIT punya beberapa file excel or apa aja deh di explorer trus mau copy list file itu ke excel. caranya mudah banget SABIT. yaitu

To get a list of filenames  (including path) into excel: 

1. Start Explorer  ( i.e. with Windows+E) 

2. Go to folder with files you want to list.

3. Select all filesnames you want to list in Excel

4. Press SHIFT + right mouse click.

5. select option " Copy as Path"

6. go to excel and paste.

Voila jadi deh

silahkan dicoba ya SABIT - sobat rabbit

Tidak ada komentar:

Posting Komentar