Chapter 2

Refining Your Worksheet

In This Chapter

arrow Changing worksheet data

arrow Going here and there in a worksheet

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

arrow Documenting a worksheet with comments

arrow Selecting cells

arrow Copying and moving data

arrow Inserting, deleting, and renaming worksheets

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

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

Get Office 2016 All-In-One 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.