Chapter 6

Feeling at Home on the Range

IN THIS CHAPTER

Bullet Selecting and formatting a range

Bullet Creating and selecting a named range

Bullet Looping through a range of cells

Bullet Inserting blank rows in a range

Bullet Unhiding all rows and columns

Bullet Deleting blank rows

Bullet Deleting blank columns

Bullet Limiting range movement to a particular area

Bullet Selecting and formatting all formulas in a workbook

Bullet Finding and selecting the first blank row or column

One of the most frequent things you do in Excel is navigate the worksheet. When ...

Get Excel Macros For Dummies, 3rd Edition 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.