3 Data Entry Methods For Microsoft Excel

3 Data Entry Methods For Microsoft  Excel 1

3 Data Entry Methods For Microsoft Excel

 

entering data directly
One of the main methods of data entry methods in Microsoft Excel is to enter the data directly into the cell, type the data and then press either the Tab or the Enter key.

You should note that pressing the Tab key will enter the data and navigate one cell to the right. Pressing Enter will enter the data and navigate to the first open cell in the next row down. 

 

 

If there is already data in the cell, The use of the direct method surely overwrites what you have entered before. 
use formula bar
Another means of entering data into any cell in Microsoft Excel is to make use of Formula Bar.
In order to do this, you have to select the desired cell, select the Formula bar to place the insertion point there, type the data, and then press either Tab or Enter. 

3 Data Entry Methods For Microsoft Excel

use of edit mode 

You can also use Edit mode to either enter new data in an empty cell or edit existing data.
Using the edit mode is more useful for editing existing data; entering edit mode is simply an extra step if you are just adding new data.
To enter edit mode using this data entry method, you either double-click the desired cell, select the desired cell and then place the insertion point in the Formula bar or select the desired cell and then press F2.

YOU CAN ALSO READ  Video: How to use IF Function to calculate Grades

In addition, Once you are in edit mode, you can place the insertion point whenever you like, in the cell or the Formula Bar, and edit the existing data as you normally would in a word processing application.
Once you have edited the data, regardless of where the insertion point is, you can press either Tab or Enter to enter the data and navigate to the desired next cell. 


Now your take on this argument.

We would also like to hear what you feel about the topic we discussed today. Your feedback is very important to us. Feel free to drop your comments and recommendations. If you have a contrary opinion, you can drop that too.

 

You can also join our Facebook Page CRMNigeria for more updates. You can do that by clicking on the link or searching for our page on Facebook.

 

Action Point.
You need to confirm your subscription by clicking on the link sent to you. You can check the spam folder for it. Add us to your mailing list to receive directly from us.

 

PS: Click on the link below to sign up for my Online E-Course CRM Training. Make sure you confirm your subscription by clicking on the link sent to you. Thanks.

 

Adeniyi Salau (CCNA,CDMP, CEP, MOS, MCP, CSCU (Project 2016), Microsoft Certified Security and Networking Associate is a Google and Beingcert Certified Digital Marketer, Project Manager and SEO Expert of repute with about a decade of Blogging and online marketing experience. He is always ready to share his experience with others.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

CommentLuv badge