Working with Ranges


In Excel, a range is a collection of two or more cells that you work with as a group rather than separately. This enables you to fill the range with values, move or copy the range, sort the range data, and insert and delete ranges. You learn these and other range techniques in this chapter.

Select a Range

Fill a Range with the Same Data

Fill a Range with a Series of Values

Flash Fill a Range

Move or Copy a Range

Insert a Row or Column

Insert a Cell or Range

Delete Data from a Range

Delete a Range

Hide a Row or Column

Freeze Rows or Columns

Merge Two or More Cells

Transpose Rows and Columns

Select and Enter Data ...

Get Teach Yourself VISUALLY Excel 2016 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.