O'Reilly logo

My Excel 2016 by Tracy Syrstad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

4. Getting Data onto a Sheet

Image
Image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required