This topic links to programming tasks (how-to and walkthrough topics) for common cells and ranges scenarios.
“How Do I …” is your gateway to key task-based topics about programming and application development using Excel. The links provide pointers to important, procedure-based help topics.
Cells and Ranges
- Create an HTML File with a Table of Contents based on Cell Data
- Describes how to take data from a worksheet and create a table of contents in an HTML file.
- Delete Duplicate Entries in a Range
- Describes how to delete duplicate entries in a range.
- Fill a Value Down into Blank Cells in a Column
- Describes how to fill a value down into blank cells.
- Hide and Unhide Columns
- Describes how to find all the cells that contain a certain value and hide or unhide the columns that contain that value.
- Highlight the Active Cell, Row, or Column
- Describes how to highlight the active cell, or column with a color.
- Make a Cell Blink
- Describes how to make a cell blink by changing the color of the cell.
- Prevent Duplicate Entries in a Range
- Describes how to prevent duplicate entries of a value in a given range.
- How to: Reference Cells and Ranges
- Describes how to reference cells and ranges in order to do enter formulas or change formats.
- How to: Refer to All the Cells on the Worksheet
- Describes how to refer to all cells on a worksheet.
- How to: Refer to Cells and Ranges by Using A1 Notation
- Describes how to refer to cells and ranges by using A1 notation.
- How to: Refer to Cells by Using a Range Object
- Describes how to refer to cells by using a Range object.
- How to: Refer to Cells by Using Index Numbers
- Describes how to refer to cells by using index numbers.
- How to: Refer to Cells by Using Shortcut Notation
- Describes how to refer to cells by using shortcut notation.
- How to: Refer to Cells Relative to Other Cells
- Describes how to refer to cells relative to other cells.
- How to: Refer to Multiple Ranges
- Describes how to refer to multiple ranges.
- How to: Refer to Named Ranges
- Describes how to refer to named ranges.
- How to: Refer to Rows and Columns
- Describes how to refer to rows and columns in Excel.
- Select a Range
- Describes how to select the used range and the data range on a worksheet.
!include[Support and feedback]