© David Slager 2016

David Slager, Essential Excel 2016, 10.1007/978-1-4842-2161-7_3

3. Best Ways to Enter and Edit Data

David Slager

(1)Fort Wayne, Indiana, USA

In this chapter, you’ll learn how Excel worksheets use three types of data: text, numeric, and date and time. It is important to understand the different types of data. You’ll also begin using special characters that you can’t find on the keyboard.

Excel has several tools and features to make your data entry quick, efficient, and in the format you want. Excel automatically determines how data is aligned based on the type of data you enter. The data you enter can be formatted by using various text, numeric, and data formats. If the data you enter doesn’t fit in the cell the way you want, you ...

Get Essential Excel 2016: A Step-by-Step Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.