Move or copy a formula - Microsoft Support
Moving a formula: When you move a formula, the cell references within the formula do not change no matter what type of cell reference that you use. Copying a formula: When you copy a …
Fill data automatically in worksheet cells - Microsoft Support
Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.
Start a new line of text inside a cell in Excel - Microsoft Support
To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press CONTROL + OPTION + RETURN to insert a line break. Press …
Issue: An _xlfn. prefix is displayed in front of a formula
An _xlfn. prefix is displayed in front of a function in a formula. When the formula is calculated, it displays the #NAME? error value. The Excel workbook contains a function that is not …
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 …
SUMIFS function - Microsoft Support
Understand the difference between SUMIF and SUMIFS. The order of arguments differ between SUMIFS and SUMIF. In particular, the sum_range argument is the first argument in SUMIFS, …
Using Solver to schedule your workforce - Microsoft Support
You can use Excel's Solver add-in to create a staffing schedule based on those requirements. The following example demonstrates how you can use Solver to calculate staffing …
Expand, collapse, or show details in a PivotTable or PivotChart ...
In a PivotTable or PivotChart, you can expand or collapse to any level of data detail, and even for all levels of detail in one operation. On Windows and the Mac, you can also expand or …
REPT function - Microsoft Support
This article describes the formula syntax and usage of the REPT function in Microsoft Excel. Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a …
IF function - Microsoft Support
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. …
Analyze trends in data using sparklines - Microsoft Support
Sparklines are tiny charts inside single worksheet cells that can be used to visually represent and show a trend in your data. Sparklines can draw attention to important items such as seasonal …