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 position: ...

Get Take Control of Numbers, 3rd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.