HomeMicrosoft OfficeExcelHow to list files of a directory in Excel worksheet ?

How to list files of a directory in Excel worksheet ?

Ever wondered how to list the names of the files in a worksheet in Microsoft Excel 2016 without using any formula ? Here’s how you can do it.

How to list files of a directory in Excel worksheet ?

1. Open the directory and copy the complete path from the Windows explorer. For example , “C:\WebCampsTK\HOL\BringingTogetherOneAspNet\Images” is the path of the folder that we cant the file names to be shown in the Excel sheet.

image

2. Open one of the web browsers and paste the path in the address bar and press enter to get the list of all files displayed in the browser.

image

3. Use the shortcut key “Ctrl + A” to select all the contents from the web browser and press “Ctrl +C” to copy.

4. Open excel workbook in Microsoft Excel 2016 and press “Ctrl + V” shortcut key. You should now see the file names in the excel sheet.

image

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021