Take Control of Numbers

Cell Basics

You’ll be spending lots of time selecting cells and moving around in tables, so knowing how to select and Move between Cells will save you lots of time; you’ll find most options are relatively intuitive even if you haven’t worked in a spreadsheet before.

This chapter also covers how to Merge and Unmerge Cells, and what happens to the data in them when you do either. (Formatting cells is covered in separate chapter, cleverly named Cell Formats.)

Cell Referencing 101

You’ve probably already realized that a single cell is named, Bingo-like, for its column and row: B2, E6, and so on.

Multiple cells in a group (referred to variously as a block, range, array, or collection) are named for the top-left and bottom-right cells, with a colon ...