Chapter 2

Entering the Worksheet Data

IN THIS CHAPTER

check Starting with a blank workbook

check Moving around the workbook

check Selecting cell ranges in a worksheet

check Doing simple data entry in a worksheet

check Using AutoFill to create data series and copy formulas

check Saving the spreadsheet as an Excel workbook file

Getting Excel off the ground (which I covered in Chapter 1) is a necessary first step, but you end up with a blank worksheet staring you in the face. Now what? Ah, that's where you put on your hat that says, “Data Entry.” Data entry refers to filling in Excel's worksheet cells with labels, numbers, dates, and whatever other data you need to get the job done. Data entry is the bread and butter of any worksheet you create or edit. As a result of doing the exercises in this chapter, you get plenty of practice in launching Excel, moving around a new worksheet, the many aspects of doing data entry, and, ...

Get Excel Workbook For Dummies, 2nd Edition 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.