O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

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

Entering worksheet data

If you’re creating a worksheet from scratch, you might be happy typing all of your data by hand. You can use the new Flash Fill feature in Excel 2013 to speed up the process and help you along the way.

Type new data

  1. Click the cell into which you want to enter text.

  2. Type the text that you want in the cell.

  3. Press the Enter key.

image with no caption

Enter data by using Flash Fill

  1. In the cell to the right of the first item in the data list, type the string you want to extract from the first value in the list.

  2. In the cell to the right of the second item in the data list, type the string you want to extract from the second value ...

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