If you accidentally delete a file or folder in OneDrive, you may be able to recover it later from the OneDrive recycle bin, and if you're a Microsoft 365 subscriber, you can even restore your entire OneDrive if something goes wrong.

Fixes an issue in which recycled files are deleted permanently if you delete files from a DFS link in a network environment on a client computer that is running Windows 7 or Windows Server 2008 R2 after you redirect the Recycle Bin to the DFS link.

Learn to delete or restore files from your OneDrive recycle bin in Android or iOS, plus how to see how much storage you have available in your personal OneDrive account.

Say you want to compare versions of a workbook, analyze a workbook for problems or inconsistencies, or see links between workbooks or worksheets. If Microsoft Microsoft 365 or Office Professional Plus 2013 is installed on your computer, the Spreadsheet Inquire add-in is available in Excel.

Restore an item from the SharePoint in Microsoft 365 site collection Recycle bin. On modern team sites and classic sites (subsites), in the left pane, select Recycle bin. On modern communication sites, select Site contents, and then select Recycle bin in the top navigation bar.

Use Spreadsheet Compare to compare two workbooks to see the differences between them, line by line. You can see how values, formulas, and formatting differ – line by line, and cell by cell. Spreadsheet Compare can detect and highlight just the type of differences you specify.

In the lower-left pane, choose the options you want included in the workbook comparison, such as formulas, cell formatting, or macros. Or, just Select All. On the Home tab, choose Compare Files. In the Compare Files dialog box, in the Compare row, browse to the earlier version of your workbook.

You can quickly compare two worksheets in the same workbook or in different workbooks by viewing them side by side. You can also arrange multiple worksheets to view them all at the same time.

You can compare two versions of a document to see how they differ. You can also merge two versions of the same document into one new document. In both cases, Word shows the differences with revision marks.

You can use the following methods to compare data in two Microsoft Excel worksheet columns and find duplicate entries. Method 1: Use a worksheet formula. Start Excel. In a new worksheet, enter the following data as an example (leave column B empty): Type the following formula in cell B1: =IF (ISERROR (MATCH (A1,$C$1:$C$5,0)),"",A1)