How To Enter Data In Microsoft Excel

Table of Contents[Show]

How To Enter Data In Microsoft Excel


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

Input Data Through Excel Cells

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

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

Input Data Via Excel Formula Bar

Input Data Via Excel Formula Bar

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

  1. Select / activate the cells where the data will be entered.
  2. Place the cursor on the formula bar
  3. Type / write the data that will be inputted into the cell on the formula bar.
  4. 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 :

  1. Select and activate the cells to be changed or edited.
  2. Activate or move cursor on formula bar.
  3. 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:

  1. Select and activate the cell that we will change its contents.
  2. Press the keys F2 on the keyboard.
  3. 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.

Leave a Comment