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).
You’ve probably already realized that a single cell is named, bingo-like, for its column and row:
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: ...