Chapter 6. How to work a worksheet

IN THIS CHAPTER, we cover the basics, including moving around within the massive worksheet grid, entering and selecting data, and working with multiple worksheets and protecting their contents. You probably already know many of these techniques, but here you’ll also learn alternative methods. You might find a better—or faster—way to do something you do frequently.

Moving around regions

A region is a rectangular range of cell entries, or a block of “filled” cells. In Figure 6-1, the range A3:E7 is a region, as are the ranges G3:H7, A9:E10, and G9:H10. (Strictly speaking, cell A1 is a ...

Get Microsoft Excel 2013 Inside Out 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.