![]() ![]() Recommendation: Use this if you only need a list of files (no subfolders) that dynamically updates itself. If you like, you could wrap the IFERROR function around in order to mitigate the error. #REF means in this case that there are no more files in your folder. That means, this argument could also be A1, C1, etc.Īs the last step: Copy the INDEX function down until you see the first #REF error. The ROW function should refer to any cell in the first row (for example to B1). Here are some very quick and simple instructions on how to create a text file listing all files and folders in a certain Windows directory. exe file and select the 'Run as administrator' option. ![]() (the command prompt will open in the path that you chose above). ![]() Press Alt -> D on your keyboard (the address bar of Windows Explorer will now be in focus). Windows 10 Instructions In Windows Explorer go to the location of the folder which you want to print a contents list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |