Microsoft Office Tutorials and References
In Depth Information
Chapter 6: Maintaining the Worksheet
Chapter 6
Maintaining the Worksheet
In This Chapter
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 2013 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 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 the 2008 depreciation schedule and its location in the
cell range AC50:AN75 so that you can remember where to find it.
In this chapter, I show you some of the more effective techniques for
maintaining and keeping on top of information. You find out how to change the
perspective on a worksheet by zooming in and out on the information, how
to split the document window into separate panes so that you can display
different sections of the worksheet at the same time, and how to keep particular
rows and columns on the screen at all times.
Search JabSto ::




Custom Search