Skip to Main Content
Office 2021 All-in-One For Dummies
book

Office 2021 All-in-One For Dummies

by Peter Weverka
February 2022
Beginner content levelBeginner
800 pages
19h 1m
English
For Dummies
Content preview from Office 2021 All-in-One For Dummies

Chapter 2

Refining Your Worksheet

IN THIS CHAPTER

Bullet Changing worksheet data

Bullet Commenting on a worksheet

Bullet Copying and moving data

Bullet 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. For the purposes of collaboration, you find out how to make comments on worksheets. 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.

Editing Worksheet Data

Not everyone enters data correctly the first time. To edit data you entered in a cell, do one of the following:

  • Double-click the cell. Doing so places the cursor squarely in the cell, where you can start deleting or entering numbers and text.
  • Click the cell and press F2. This technique also lands the cursor in the cell.
  • Click the cell you want to edit. With this technique, you edit the data ...
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

Office 2021 for Macs For Dummies

Office 2021 for Macs For Dummies

Bob LeVitus, Dwight Spivey
Microsoft Office 2021 – Das Handbuch

Microsoft Office 2021 – Das Handbuch

Rainer G. Haselier, Klaus Fahnenstich
The Frictionless Organization

The Frictionless Organization

Bill Price, David Jaffe

Publisher Resources

ISBN: 9781119831419Purchase Link