While macros can be created using code, they can also be created by having Excel record your actions. It is very simple. I illustrate, in the accompanying video, how to record a macro in Excel using ...

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

An Excel macro is a sequence of commands (or directives) that you record to perform a series of tasks. We'll show you how to create custom macros for your spreadsheet.

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