Chapter 11
Refining Your Worksheet
In This Chapter
Freezing and splitting columns and rows to make data entry easier
Selecting, copying, and moving data
Moving among, deleting, and renaming worksheets
Hiding and protecting worksheets so that they can’t be altered
Constructing a basic formula
Preventing errors in formulas
Using functions in formulas
This chapter delves into the workaday world of worksheets (say that three times fast). It explains how to edit worksheet data and move quickly here and there in a worksheet. You also discover techniques for entering data quickly, selecting cells, and copying and moving data in cells. This chapter describes how to move, delete, and rename worksheets, as well as protect them from being edited or altered.
Formulas are where it’s at as far ...
Get Office for iPad and Mac For Dummies 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.