Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.

How to Format Relative References in Excel. Microsoft Excel relies on two fundamental reference types when addressing other cells. Absolute references -- which are denoted with a "$" -- lock a ...

These days, you can still use macros in Excel, but you need to enable the macro feature to do so. Here's how to enable (and disable) macros.

By default, references in Excel use the A1 reference style, which means that it refers to the column first, and then the row number. However, the INDIRECT function enables you to switch these around.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

How to make a macro to move or copy data in Excel? Let's take a case in which you need to copy data from one workbook and then amend the content to another workbook.