**Excel Data Input **- An equally important part of
learning to use Microsoft Excel is knowing how to enter data into cells on a Microsoft Excel worksheet and how to change or edit the contents of the Excel
cells.

## How to Enter Data in Excel

To manually input data into Excel cells, there are several ways we can do it. The first way is to enter data through Excel cells directly and the second way is to input data from the formula bar.

**Input Data Through Excel Cells**

To manually input data into Excel cells, the steps
required are as follows:

- Select / activate the cells where the data will be entered.
- Type / write the data that will be inputted into the cell.
- Press Enter to confirm data input.

**Input Data Via Excel Formula Bar**

If you want to input data from the formula bar the
required steps are as follows:

- Select / activate the cells where the data will be entered.
- Place the cursor on the formula bar
- Type / write the data that will be inputted into the cell on the formula bar.
- Press Enter to confirm the data input.

What data types can we enter into an Excel cell? The answer can be found here: Data Types in Excel

## How to Confirm Data Input in Excel

After finishing typing data or writing data into Excel cells, the usual method is to press a key Enter on the keyboard. Another way is to move the active cell.

Apart from pressing enter, there are actually several other ways to confirm this data. This depends on which cell you want to activate after confirming the data.

KEYBOARD | CONFIRMATION |
---|---|

Enter | Move 1 cell down or activate the cell below the active cell |

Shift + Enter | Move 1 cell up or activate cells above the active cell |

Tab | Move 1 cell to the right or activate cells to the right of the active cell |

Shift + Tab | Move 1 cell to the left or activate cells to the left of the active cell |

Apart from using the keyboard keys above, if you use the first method (input data directly in the active cell) you can also move or confirm using the arrow keys on the keyboard.

## How to Change or Edit Excel Cell Contents

After confirming the data entry in a cell, if you find a certain error and intend to change the contents of the cell, the method is as follows:

**First step**

The first way is to edit cells via the formula bar :

- Select and activate the cells to be changed or edited.
- Activate or move cursor on formula bar.
- Do the editing as necessary.

**Second Way**

Apart from going through the formula bar, we can also
change the contents of an Excel cell directly in the following ways:

- Select and activate the cell that we will change its contents.
- Press the keys F2 on the keyboard.
- Do the editing as necessary.

Steps 1 and 2 in the method above can also be replaced by double clicking (Double click) on the cell that we will change its contents.

## How to Delete Excel Cell Contents

To delete the entire cell contents, use the keys Delete on the keyboard.

This is the basic excel tutorial series for beginners this time that discusses how to enter data in Microsoft Excel.