3 data entry method for microsoft excel to save time

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 4,506 other subscribers

Here are the three data entry method in Microsoft Excel…..

 

entering data directly

One of the main methods of data entry 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. 

 

data entry method

If there is already data in the cell, The use of 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. 

 

 

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.

 

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. 

 

 

 

Action Point

If you enjoy our article, sign up to get our next article in your inbox.

 

 

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. Thanks.

   

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.

image_pdfGENERATE PDFimage_printPRINT
About crmnigeria 77 Articles
Adeniyi Salau C.E.P. C.S.C.U, M.C.P., M.C.T.P (MICROSOFT PROJECT 2016), Hubspot Inbound Marketing Expert is a Digital Marketer of repute who is committed to sharing his knowledge with readers out. He strongly believe I.T Knowledge is for everyone. He is already championing that cause.

Be the first to comment

Leave a Reply

Your email address will not be published.


*


CommentLuv badge