MS Excel: How To Enter Data In Excel

Excel Data Input

Excel Data Input makes your work more efficient or easy in your day-to-day work.

1. Cell Edit Mode

Excel provides a simple or common way to enter data into a spreadsheet Excel simply clicks on a single cell and starts entering the data. The cell which you select automatically turns into an Edit Mode but when you select a different cell or clicked enter then the data you entered into the cell, remains in the cell and the edit mode exits automatically.

After some time when you clicked on the same cell again and start typing then the new data will override the previous data or the data already exists in the cell.

So, if you want to edit the data of a cell without deleting the existing data of the Excel cell then you just simply need to put the cell into edit mode before you start to enter new data into the cell with existing data.

Follow the below-mentioned steps to enable Edit Mode in Excel on a particular cell:

• Double click on a cell in the Worksheet of Excel, Or
• Click on a cell (you want to edit) and then either click in the formula bar available at the top or Press F2 in your keyword.

If the Edit mode got enabled on a cell then a cursor will appear either in a cell or the formula bar. Then simply enter your data that will append into the cell with your previous data. Also, you can move your cursor (using mouse or keyboard left-right keys) before or after inside the cell if the Edit mode is enabled.

2. Entering Same Value Into A Range Of Cells

Excel also provides an amazing feature to add the same text or data into more than one cell at a time without adding much effort. This process of populating the same data into multiple cells is very simple just follow the below-mentioned steps:

• Do highlight the cells among which you want to populate the same data.
• Enter the data after highlighting the cells.
• Press Ctrl + Enter on your keyboard to populate the same data among all the cells.

This a very simple process and now your data is populated into all the cells as required. The below-attached image also can refer.

3. Entering Series of values

MS Excel is a very good tool when we want to enter values in series in less time. This feature of Excel is known as Excel Autofill. Give attention to the below-mentioned steps for the autofill feature:

• First you need to select a cell and enter some value into the cell.
• Now, drag the "Fill handle" to populate the data among the range of cells selected.
• "Fill handle" nothing but the square symbol at the bottom right of the selected cell as shown in the image.

4. Import Data Into Excel Worksheet

Excel also has a feature called Import by using this feature user can add a file to Excel of different file format. Follow the below steps for more clarity:

• Go to Data option available in the header section.
• Now, Click on Get External Data and select From Text option.
• Choose a file from your computer/laptop to add to an Excel spreadsheet.

Now, you have to follow some steps that will guide you to split the data into columns in the Excel spreadsheet.