One of the main advantages when working with this calculation program, is that its users will have the opportunity to input a large amount of data into the all of these types of data can be entered manually in one or several cells simultaneously, as can also be done in multiple spreadsheets at once.
In this case you can enter different types of data such as numbers, text, dates, times, labels, functions, formulas, among many others. You can too configure some aspects which will allow you to enter everything is in a much easier and faster.
Keep in mind that in order to work on these spreadsheets it is mandatory know how to enter this type of informationthis is how we are going to explain in detail here How can you enter data in a Microsoft Excel worksheet? To do this, follow everything that we are going to explain below in the post.
What are all the types of data that can be entered into a spreadsheet?
In order to make use of this type of program, it is very important to know what all of them are. data types that can be enter into worksheetsince this will allow you get the most out of each of your projects. In this way, here we show you what type of information you can start adding in Microsoft Excel.
To do this, follow each of the elements that we will teach you below:
labels
One of the most common elements to add when working with this software are the labelsthe same are any type of annotation that contains at least one alphabetic character, this can be in uppercase or lowercase. Some examples of these are the following:HELLO, hello, A458, 855B, 230D”, among many others.
As you can see, these are data that cannot be used in any type of Math operation, since the same simply would generate an error. Furthermore, these Label types cannot be more than 255 characters long and are aligned to the left of the cell. These types of annotations are mainly used to generate serials and codes.
long labels
In the case of the long labels are considered as the only annotations able to cross cell boundsthese always lengthen to the right of it as long as the cell on the right does not contain any information. In the event that it ends occupying two or more cells and want to modify some aspect of the annotation that has been added there, it must be done from the original cell.
Since at entering a data in the cell on the right side will automatically be displayed and you will only be able to see what the original cell covers or to the cell where cut off annotation display. As can be seen in the image shown, it can be seen that in the first example annotation looks complete and spans multiple cellsit starts from cell B4 and ends up to cell G4.
But in the example below the pictureIt can see how the label is cut when entering a new data in cell D4, in this case the annotation display you can only view from cell B4 to cell C4.
common numbers
Other elements that can be added to this spreadsheet are common numbers, keep in mind that these numbers differ in several aspects with those who can be entered for formulas and for functions.
Accordingly, here are some characteristics of common numbers:
- The “+” sign in front of the number will be ignored by the program.
- A eat will be considered as a decimal point.
- can be placed percentages 1.10%
- The negative will be -12 or (12).
- Fractions are allowed to enter ½ score 0 ½ and for 3 3/5 score 3 3/5
formulas
So that Excel I can take one number sequence as a formula and from there make a mathematical calculation operation This must contain a series of aspects.
Which are:
- None numbers can go with a period (.)
- should not be included negatives with ()
- Must start with the symbol (=) or the sign (+).
- Can be done any type of mathematical operation.
- should be used parentheses to separate terms.
functions
In the case of functions, they are considered as a series of predefined formulas whose mission is to execute calculations through specific values, in this case they can carry out operations of , , , equations, among others.
dates and times
Dates and times in Excel can be used in different waysIn general, these tend to appear in the spreadsheet according to the number format applied in the cell. This means that when add a time or a date to one of the cells, The program will automatically recognize the format of the cell and will change it to the general appearance of the format that is being used.
These types of values are entered defaults to the right side of the cell. In the case that Excel does not recognize the values as date or time, it will be entered as if out text, for what this will be aligned to the left of the cell.
Among some of the formats available for both cases are the following:
- 4/3/94 d/mm/yy
- 4-mar-94 d-mmm
- Mar-94 d-mmm-yy
- 8:50 a.m. h:mm am/pm
- 20:50 h:mm (24 hours)
- 8:50:35 a.m. h:mm:ss am/pm
It is also possible that it can place a date and time together or separated by a space as seen in these examples: 4/3/94 20:50 d/mm/yy h:mm.
Learn step by step how to enter data in an Excel spreadsheet
Taking into account that types of data can be entered into the spreadsheetthe next thing you should do is put them in the same so you can start work on itkeep in mind that this is the first step that must be carried out in order to be able to work in microsoft excel. Therefore, here we teach you step by step how to enter data in your worksheet.
To do this, follow each of these instructions that we will teach you below:
select cell
The first step to perform is to select the cell where you want to enter the data, in this case the selection can be made with the help of the mouse or keyboard, in the case of mouse when you move it over the worksheet it will take the shape of a white crosshere you simply have to click on the cell you want to use and it will become a active celleverything that is written there will remain registered in the box, be it letter, numbers or signs.
Another way to check the boxes is moving with the keyboard, for this make use of the arrows and move to the square you want to choosein the event that you want to go to a cell that is very far away, then you can use the name box, there you introduce the letter and number of the box and you press the key “Enter” and you will automatically appear in it.
Introduce data
Once the cell has been selected, the next step you must perform is enter the information that will be contained in itit will also be reflected in formula bar and two buttons appear, one of them allows cancel and confirm the data that has been written there. When you have written the content in the box, you simply have to press the key “Enter” or click any other so that the content is registered there.
In the case of pressing the enter key will automatically select the bottom cell. This allows you to create vertical data lists quicklysimply adding the information and pressing the enter key as often as necessary. Now if what you want is add data horizontally can you help with keyboard scroll arrowsthis will have the same effect as pressing enter.
Copy and paste
another form of power enter data into your spreadsheet is through the tools of copy and pastein this case you can copy the information you want embed from a website, document or blog and then copy it in the corresponding box. This will allow you to work more quickly when you need transport data from one site to another. In order to apply this function, you need to select the content you want to copy.
then right click and select copy item, then you must go to worksheet and there select the cell where you want copy the informationonce selected right click on it and choose “Paste” or just press the key combination “Ctrl + V” simultaneously. this way you will be adding information to excel.
Find and replace information
You can too add data using the tool “Find and replace information” this in case you need to search for a cell that contains some specific data and you want to change them to introduce new ones.
To do this you can do it in the following ways:
Search
To be able to search for a specific cell you can do it with the function “Search” You can apply the same by pressing the key combination “Ctrl + B”. To apply this you can locate yourself at the beginning of the sheet and there you select the edition search and write the content you want to find. You will immediately be sent to the cell that contains the information you marked.
Replace
In the case of replace you must indicate what you want to achieve and what you want to be put in its placethat is, if the word is on your sheet begin, but you no longer want to have it and you want to change it for start, then then indicate that the word “Start” is found but it is changed to “Start”. You can open this function by pressing “Ctrl + L” with your keyboard.
spell check
When you apply a spell check in Microsoft Excel it is quite possible that he program dictionary advise you insert new words or that you change some of the ones that already appear there for some new. These revisions can be applied to the entire text there present as for graphics.
Therefore, when applying this function you will find Suggestions of possible words you must correctin this case you can indicate ignore them this time, for the rest of the document or add the word to the dictionary or replace it with the one suggested there. To apply this function you must go to the ribbon and select the tab “Check” and there you enter the category of “Orthography”.
align data
Once the data is inserted in each of the Excel cells, It is very important that these are aligned, as this will help you to put them in the right position depending on what you are looking for, for this you must go to the tab “Start” and in the section “Alignment” you will find all the necessary options so that you can adjust all the information you have over there.
Format the data
not only recommended align databut it is also advisable that they be given a format to them, in this case you can…
Facebook Comments
Disqus