If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.

But, you can use Excel to view files and folder details of a directory, which would be helpful to you to know at least the list of files and folders that were deleted.

Here's a quick tip for creating a Microsoft Excel drop down list from another tab.

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

Learn how to easily set up your own search field in Excel to find and filter content within a table.