Chapter 4. Editing in a Spreadsheet

4. Editing in a Spreadsheet

IN THIS CHAPTER

• Renaming a spreadsheet

• Moving information

• Copying information

• Inserting and deleting rows and columns

• Hiding and redisplaying rows and columns

• Locking row and column titles onscreen

If you've been reading straight through, go take a break or you'll fall asleep. Stand up and stretch, get some chocolate or caffeine (or both), and then come back and start learning about editing in a spreadsheet.

You'll probably spend more time editing in a spreadsheet than you will doing any other activity, including producing reports or graphs. And, there are lots of ways to edit information in a spreadsheet. In Chapter 3, I showed you how to enter information into a cell, make corrections to that information, and fill a range with commonly used labels such as months. In this chapter, I'll take things a step further.

In this chapter, you'll learn how to how rename a spreadsheet, how to move and copy information from one location to another in a spreadsheet, how to insert, delete, hide, and redisplay columns and rows, and how to lock a set of rows and columnsusually the ones containing the titles of the information you are enteringonscreen so that you can always identify the information you're viewing or entering.