This topic links to programming tasks (how-to and walkthrough topics) for common Excel scenarios.

"How Do I ..." is your gateway to key task-based topics about programming and application development using Microsoft Office Excel. The essential categories for what you can do with Excel are listed in this topic. The links provide pointers to important, procedure-based Help topics.

Workbooks and Worksheets

Describes how to create a workbook using Excel.
Describes how to refer to more than one worksheet in Excel.
Describes how to refer to worksheets by index number.
Describes how to refer to worksheets by name.

Cells and Ranges

Describes how to reference cells and ranges in order to do enter formulas or change formats.
Describes how to refer to all cells on a worksheet.
Describes how to refer to cells and ranges by using A1 notation.
Describes how to refer to cells by using a Range object.
Describes how to refer to cells by using index numbers.
Describes how to refer to cells by using shortcut notation.
Describes how to refer to cells relative to other cells.
Describes how to refer to multiple ranges.
Describes how to refer to named ranges.
Describes how to refer to rows and columns in Excel.

Controls, Dialog Boxes, and Forms

Describes how to add controls to a document.
Describes how to add controls to a user form.
Describes how to create a custom dialog box.
Describes how to create a user form.

See Also