Overview of formulas in Excel - Microsoft Support
Get started on how to create formulas and use built-in functions to perform calculations and solve problems. Important: The calculated results of formulas and some Excel worksheet functions …
Overview of diagnostic log files for Office - Microsoft Support
When a user runs an Office app, such as Word or Excel, diagnostic information is collected and saved to log files on the user’s device. These log files contain information about the processes …
Fill a formula down into adjacent cells - Microsoft Support
Follow these steps to fill a formula and choose which options to apply: Select the cell that has the formula you want to fill into adjacent cells. Drag the fill handle across the cells that you want to …
Basic tasks in Excel - Microsoft Support
Cells can contain numbers, text, or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build …
COUNTIF function - Microsoft Support
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its …
Manage workbook links - Microsoft Support
Here's how to ensure that you are retrieving the latest values from your source workbooks. Sometimes, you need to change the source workbook, a workbook link breaks, or you may no …
Save a workbook as a template - Microsoft Support
Excel creates a new workbook that is based on your template. If you often use the same layout or data in a workbook, save it as a template so you can use the template to create more …
Apply sensitivity labels to your files and email - Microsoft Support
You can apply sensitivity labels to your files and emails to keep them compliant with your organization's information protection policies.
Sensitivity labels are automatically applied or recommended for …
Microsoft 365 can be configured to recommend or automatically apply a sensitivity label to a file or email if it includes sensitive corporate or personal information, such as social security …
Excel specifications and limits - Microsoft Support
In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns. In this article, find all workbook, worksheet, and feature specifications and limits.
View previous versions of Office files - Microsoft Support
Restore a previous version of an item or file in SharePoint. Enable and configure versioning for a list or library. Use Version History to view previous versions of files stored in OneDrive or …