My Excel 2016

4. Getting Data onto a Sheet

You never know where your data is going to come from—manually typed in, imported or copied from another file, or from the Web. Because of this, Excel offers a multitude of ways to enter data. In this chapter, you’ll learn those ways and also the following:

→ Entering different types of data

→ Quickly copying data using the fill handle

→ Working with lists

→ Using Text to Columns

→ Controlling user entry with Data Validation

→ Spell checking a sheet

→ Finding data on a sheet

→ Fixing numbers stored as text

Data entry ...