How to Enter Data into a cell using the Formula Bar

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

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 second option of entering the data into the formula bar.

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: Select Formula Bar 

The formula bar is outlined in red below. Left click inside the white area of the formula bar and you will see the cursor appear as seen below in the red outlined area.

Step 3: Enter data into the formula bar

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.

Congratulations, you have entered data into a a cell within an Excel 2010 worksheet.  Feel free to check out my Cell Tutorials and my Formula Tutorials .