How to Enter Data into Excel

Add to Favorites
Author:

Entering data into Excel is exactly the same across all Excel versions and can be done in a number of different ways.

The first way you can enter data into Excel is using the formula bar. First you click on a cell, A1 for example and then you click on the formula bar so that the cursor appears within it.

 

You can now type using the keyboard to enter data into cell A1. I typed Hello! into the formula bar and it also appears in the cell I had selected (A1):

 

This also works by typing directly into the selected cell (without clicking on the formula bar). So if I select cell B2 and type World! it appears in the selected cell and the formula bar in exactly the same way:

 

If you dont like what youve typed into a particular cell you can undo the action much like in Word and other Office programs. This is done by clicking the Undo button. This is the backwards pointing arrow in the top left corner of Excel. By hovering the mouse over this button the undo action that will be performed is shown. So as the last thing I did was type World! into cell B1, clicking the undo button will remove world from cell B1.

 

In addition to the Undo button there is also the Redo button. This is the forward pointing arrow and this re-does what you have just undone with the Undo button. So as I just used Undo to remove World! from cell B2, the Redo button will re-enter World! into cell B2.

 

Alternatively I could have used the keyboard shortcut Ctrl + Z to undo and Ctrl + Y to redo. These work the exact same way as clicking the buttons.

The Ctrl + Y shortcut for redo has some additional functionality. It can be used to repeat actions such as copying formats to other cells. I will go through how this feature works in more detail in the next tutorial as it saves time when making changes to individual or groups of cells.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Use a Form to Enter Data into a Table in Excel
Tutorial: You can enter data into a table in Excel using a form; here I'll show you how to do that....
Put Data into a UserForm
Tutorial: How to take data from Excel and put it into a UserForm. This is useful when you use a form...
Put Data into a Worksheet using a Macro in Excel
Tutorial: How to input data into cells in a worksheet from a macro. Once you have data in your macro...
VBA Macro to Import Web Data into Excel
Tutorial: It's time to learn how to use VBA and Macros to import data from a web page into Excel! T...
How to Use Dates in Excel
Tutorial: Introduction Guide to using Dates in Excel - this tutorial will show you how to input and...
Simple Alternatives to UserForms
Tutorial: This tutorial covers a few simple ways to show pop-up windows to users that allows you to ...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course