Overview of data types in Access desktop databases, and detailed data type reference, including Short Text, Long Text, and Date/Time.

Microsoft Support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows 11, Surface, and more.

Use data validation rules to control the type of data or the values that users enter into a cell. One example of validation is a drop-down list (also called a drop-down box or drop-down menu). Watch …

Create a list of valid entries for the drop-down list, typed on a sheet in a single column or row without blank cells. Select the cells that you want to restrict data entry in. On the Data tab, under Tools, …

How to use AutoFilter in Excel to find and work with a subset of data in a range of cells or table.

Sorting data is an integral part of data analysis. You might want to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or order rows by colors or …

PivotTables Data models You can use Power Query (formerly called Get & Transform) experience to connect to multiple data sources, then use the Query Editor to shape and transform data. Power …

Open and close Outlook Data Files (.pst) that contain copies, archives, or backups of your Outlook information.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

Learn about storage settings in Windows and how reserved storage works to conserve disk space for temporary files, caches, and other files.

Select Clear now. Clear browsing data stored in the cloud (if you’ve turned on sync or personalization) To manage and delete data saved in the Microsoft cloud, see the privacy dashboard. On the privacy …