Entering Values on a Worksheet

You can enter values as whole numbers, decimals, percentages, or dates using the numbers on the top row of your keyboard, or by pressing your Num Lock key, the numeric keypad on the right. When you enter a date or the time of day, Excel automatically recognizes these entries (if entered in an acceptable format) as numeric values and changes the cell’s format to a default date or time format. You can also change the way values, dates or times of day are shown.

Enter a Value

Image Click the cell where you want to enter a value.

Type a value.

Press Enter, or click the Enter button on the formula bar.

Did You Know? ...

Get Excel® 2013 On Demand 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.