Convert a database to the .accdb file format. Convert an .accdb database to an earlier file format. This article explains which Access file format you would use based on your needs, and why you might want to use an earlier version file format in some instances.

Restore deleted files and folders or restore a file or folder to a previous state. Navigate to the folder that used to contain the file or folder, right-click it, and then select Restore previous versions. If the folder was at the top level of a drive, for example C:\, right-click the drive, and then select.

All Outlook Data Files (.pst) and Offline Data Files (.ost) are listed along with the name of the account the files are associated with. If you cannot open your Outlook data file or suspect that the file is damaged, use the Inbox Repair tool (scanpst.exe) to repair errors in the file.

Structured reference: (DeptSales [ [#Totals], [Sales Amount]] and DeptSales [ [#Data], [Commission Amount]] are structured references, represented by a string that begins with the table name and ends with the column specifier. To create or edit structured references manually, use these syntax rules:

Microsoft Office uses the XML-based file formats, such as .docx, .xlsx, and .pptx. These formats and file name extensions apply to Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

From this page, you can view items that are currently in a user's Recycle Bin and items that a user has deleted from his or her Recycle Bin, sending the items to the second stage Recycle Bin also known as the Site Collection Recycle Bin.

Use the Office offline installer to install Office 2016 or Office 2013 if you don't have an active Internet connection or you're having problems with slow speed or unreliable connections.

If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells. By default, Excel copies hidden or filtered cells in addition to visible cells. If this is not what you want, follow the steps in this article to copy visible cells only. For example, you can choose to copy only ...

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.