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 may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
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 and components running in the application, and can help detect, diagnose, and fix issues and help make improvements to Office.
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 fill. If you don’t see the fill handle, it might be hidden. To display it again: Click Advanced.
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 great-looking charts. Let’s go through the basic steps to get …
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 simplest form, COUNTIF says: =COUNTIF (Where do you want to look?, What do you want to look for?) For example:
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 longer need the workbook link. There is no automatic way to find all workbook links in a workbook.
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 workbooks instead of starting from scratch.
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 numbers, credit card numbers, or bank account numbers.
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 …