I’m using Microsoft 365 on a Windows 10 64-bit system. The FILTER() function is available in Microsoft 365, Excel Online, Excel 2021, Excel for iPad and iPhone and Excel for Android tablets and ...

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you ...

You can even merge and unmerge cells in Excel. How to use functions and formulas. The real power behind Microsoft Excel is the ability to manipulate data that includes using functions and formulas.