O'Reilly logo

Office for iPad and Mac For Dummies by Peter Weverka

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11

Refining Your Worksheet

In This Chapter

arrow Freezing and splitting columns and rows to make data entry easier

arrow Selecting, copying, and moving data

arrow Moving among, deleting, and renaming worksheets

arrow Hiding and protecting worksheets so that they can’t be altered

arrow Constructing a basic formula

arrow Preventing errors in formulas

arrow 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required