Master Cell Basics

You’ll spend lots of time selecting cells and moving around in tables, so knowing how to select and Move Between Cells, and Move Within a Block of Cells saves a lot of time. This chapter also covers how to Move a Cell or Its Data and Merge and Unmerge Cells (and explains what happens to their data when you do either).

Cell Referencing

You’ve probably already realized that a single cell is named, bingo-like, for its column and row: B2, E6, and so on. A selection of multiple cells, referred to variously as a block, range, or array, is named for its top-left and bottom-right cells, with a colon between: B5:D10, for instance.

When you refer to a cell in another table on the same sheet, you can refer to it by its row/column ...

Get Take Control of Numbers, 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.