Chapter 6

Maintaining the Worksheet


Zooming in and out on a worksheet

Splitting the workbook window into two or four panes

Freezing columns and rows onscreen for worksheet titles

Attaching comments to cells

Naming your cells

Finding and replacing stuff in your worksheet

Looking up stuff using online resources in the Research task pane

Controlling when you recalculate a worksheet

Protecting your worksheets

Each worksheet in an Excel 2016 workbook offers an immense place in which to store information. But because even a regular size computer monitor (which is quite large when compared to a regular Windows tablet or smartphone screen) lets you see only a tiny bit of any of the worksheets in a workbook at a time, the issue of keeping on top of information is not a small one (pun intended).

Although the Excel worksheet employs a coherent cell-coordinate system that you can use to get anywhere in the great big worksheet, you have to admit that this A1, B2 stuff — although highly logical — remains fairly alien to human thinking. (I mean, saying, “Go to cell IV88,” just doesn’t have anywhere near the same impact as saying, “Go to the corner of Hollywood and Vine.”) Consider for a moment the difficulty of coming up with a meaningful association between a 2015 depreciation table and its location in the cell range AC50:AN75 so that you can remember where to find it in your income tax worksheet.

In this chapter, I show you some of the more effective techniques for maintaining ...

Get Excel 2016 For Dummies now with the O’Reilly learning platform.

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