Microsoft Excel is one of the leading data organizing and analyzing programs. But to analyze data in Excel, you need to input data first. Data can be of different types. Based on the data types, there are different techniques to insert them in Microsoft Excel. In this article, I will discuss various types of data entry in Excel.
Types of Data in Excel
Data is the heart of MS Excel. It deals with data and generates an output. You will find 4 types of data in Excel. They are,
- Text
- Value
- Date
- Formula
Text Type Data: They are alphanumeric mostly. This means both the alphabet and numbers include this data type. Examples: Alexi Laiho, Area 51, etc.
Value Type Data: The Value type data completely refers to the numerals data. Examples: 5, 7, 343.556, etc.
Date Type Data: They can be a short date as well as a long date format. Example: 6/13/2022, Monday, May 23, 2016, etc.
Formula Type Data: Values, Functions, and Operators create formulas. Example: =SUM(A2:H2)+92.
Types of Data Entry in Excel: A Quick Overview
Just look at the following dataset. Here, I used all the 4 types of data available in Excel.
Throughout the article, I will show you the ways and rules regarding these 4 types of data entry in Excel.
1. Text Type Data Entry
Text type data is consist of both numbers as well as values. A single cell in Excel supports up to 32,000 characters.
When you want to insert letters, you don’t need to think about anything. But when you want to insert values as texts, you have to insert an apostrophe before the numbers.
Let me show you how to insert a Text type data first.
❶ Click on a cell, then press F2 to enable editing.
Or, just double-click on a cell to enable editing.
❷ Then type the text data.
❸ After that, press the ENTER button to insert the Text type data.
To insert the numeric values as a Text type data,
Just use an apostrophe (‘) before the number and press ENTER.
Excel will automatically format the value as text-type data.
The apostrophe doesn’t appear in the cell.
If you click on the cell, an error icon appears. Click on the error drop-down icon, and it will show ‘The number in this cell is formatted as text or preceded by an apostrophe.’
To ignore the error, click on the error drop-down icon. Then select Ignore Error.
2. Value Type Data Entry
The entry method of a value-type data is as same as that of the text-type data.
Yet, I’m showing you how to insert the value type data.
❶ Click on a cell, then press F2 to enable editing.
Or, just double-click on a cell to enable editing.
❷ Then type the values inside the cell.
❸ After that, just press the ENTER button to insert the data into the cell.
To format the values, select the cell first.
Then go to Home ➤ Number.
After that, choose any formatting type from the Number group.
For this instance, I’m selecting the Accounting type format.
You can also autofill the value-type data using the Fill Handle.
Just keep the mouse cursor at the bottom-right corner of the cell where you’ve inserted the value-type data.
The cursor will turn into a plus icon ‘+’.
Press and hold the left mouse button. Then drag it down all the way.
It will autofill the rest of the cells of the same column.
3. Date Type Data Entry
Excel stores the date-type data as decimal values. That’s why date can be used inside functions and formulas.
To insert date-type data,
❶ Click on a cell, then press F2 to enable editing.
Or, just double-click on a cell to enable editing.
❷ Then type a date inside the cell.
❸ To insert the date into the cell, press ENTER.
To add more formats to the date, press CTRL + 1 with the data selected.
The Format Cells will appear.
- Now go to Number ➤ Date.
- From the Type section, select any format that you want.
- Then click OK to apply.
You can also autofill the date-type data using the Fill Handle.
Just keep the mouse cursor at the bottom-right corner of the cell where you’ve inserted the date-type data.
The cursor will turn into a plus icon ‘+’.
Press and hold the left mouse button. Then drag it down all the way.
Excel will automatically fill up the rest of the cells with a sequence of dates.
Read More: How to Automatically Insert Timestamp Data Entries in Excel
4. Excel Formula Type Data Entry
Formula-type data comprises Functions, values, and operators.
To insert formula-type date,
❶ Click on a cell, then press F2 to enable editing.
Or, just double-click on a cell to enable editing.
❷ Then type the formula.
For this instance, I’ve used the following formula having the ROUND, DAYS, & NOW functions.
=ROUND(DAYS(NOW(),D5)/365,0)
This formula calculates the total working period from the jointing date of each employee.
You can also autofill the formula-type data using the Fill Handle.
Just keep the mouse cursor at the bottom-right corner of the cell where you’ve inserted the formula-type data.
The cursor will turn into a plus icon ‘+’.
Press and hold the left mouse button. Then drag it down all the way.
The Fill Handle will copy down the formula all the way. And you will see the formula result like this:
You can also do so many things with the formulas.
For example, you can add text and formula at the same time using the CONCAT function.
=CONCAT(ROUND(DAYS(NOW(),D5)/365,0), " Years")
Formulas are not restricted to these, Excel provides many Text, Math, Date & Time, and many more.
Read More: How to Restrict Data Entry in Excel Cell
Things to Remember
- The value-type data supports only the following characters: 1 2 3 4 5 6 7 8 9 0 + – ( ) , / $ % . E e.
- To insert a date in Excel, make sure you insert the month first, followed by the day and year respectively.
Download Practice Workbook
You can download the Excel file from the following link and practice along with it.
Conclusion
To sum up, we have discussed types of data entry in Excel. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap.
Such Blogs are useful to enthusiastic persons. I am benefited as a novice.
Dear Paresh Kanti Paul,
We are glad to hear that.
Regards
ExcelDemy