3. Getting Data onto a Sheet

In This Chapter

• Learn the different types of data.

• Enter data into a cell.

• Quickly copy data using the fill handle.

• Fix numbers stored as text.

Data entry is one of the most important functions in Excel—and one of the most tedious, especially when the data is repetitive. This chapter shows you tricks for copying down data, fixing entered data, and helping your users enter data correctly by providing a predefined list of entries.

Types of Data You Enter into Excel

It’s important to differentiate types of data because Excel treats each differently. You tell Excel what kind of data is in a cell by how you type it into the cell or by how you format the cell. Data in Excel can fall into one of four categories. ...

Get Excel® 2013 Absolute Beginner’s Guide 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.