How to Enter Data into a Cell


In this tutorial I will teach you how to enter data into a cell within an Excel 2010 worksheet.

This is a very basic tutorial, but I want to ensure that everyone understands this so they can follow along with my future tutorials.

For this tutorial you will need a workbook open within Excel 2010.

There are two basic ways two enter data in Excel 2010:
  1. Typing into the cell
  2. Formula bar
Both of these ways provide the same result. They both have their advantage and disadvantage. If all you want to do is type one value or a short value then you will mostly like just select the cell you want and start typing. However, if you want to enter a lot of data or enter a formula you might like the formula option because it allows you to see more of what you are entering.
For the purpose of this tutorial we will use the first option of just selecting the cell we want and start typing.
Step 1: Select a cell within the Excel 2010 workbook.
It doesn't matter which cell it is. For the purpose of my tutorial I chose the very first cell A1.








Notice the black outline where column A meets row 1 this is cell A1. That black outline tells you which cell is selected.
Step 2: Enter data

Type anything you want. It doesn't matter for the purpose of this tutorial I typed the number 1.







Notice is this picture you see the keyboard cursor to the right of the number 1 that I entered already. This is just saying that if you keep typing it will keep adding whatever you type to that cursor location.
In the blue outlined area is the Name Box. By default the name box displays the selected cell.

In the red outlined area is the formula bar. Notice that in the formula bar that number one is also shown, but without the keyboard cursor. The formula bar will always show the value of the cell unless the value of the cell is the result of an equation.
Congratulations, you have entered data into a a cell within an Excel 2010 worksheet.  Feel free to check out the rest of my Cell Tutorials.

No comments:

Post a Comment