One of the most frequent requests I receive from readers is how to highlight list values when they change. Conditional formatting is the answer, however, even though you might try the right ...

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.

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.

Excel displays the error message "Cannot extend list or database" if your new data record has to delete existing data. Data forms add records into a row directly after your last record.