Skip to Main Content
Office for iPad and Mac For Dummies
book

Office for iPad and Mac For Dummies

by Peter Weverka
March 2015
Beginner to intermediate content levelBeginner to intermediate
384 pages
8h 17m
English
For Dummies
Content preview from Office for iPad and Mac For Dummies

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Reinventing the Organization for GenAI and LLMs

Reinventing the Organization for GenAI and LLMs

Ethan Mollick

Publisher Resources

ISBN: 9781119010180Purchase book