How to Enter Data into Excel

Add to Favorites
Author: don

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.

Question? Ask it in our Excel Forum


Downloadable Files: Excel File

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 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...
Simple Alternatives to UserForms
Tutorial: This tutorial covers a few simple ways to show pop-up windows to users that allows you to ...
Easily Enter Fractions into Excel
Tutorial: This is a very simple trick to enter fractions quickly without having to manually format ...
What is a UserForm in Excel?
Tutorial: A UserForm is basically a pop-up window that you can use to create a custom interface for ...
How to Find and Understand Excel Functions
Tutorial: In this tutorial I am going to show you how to find and understand new Excel Functions. If...
Tutorial Details
Downloadable Files: Excel File
Similar Content
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 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...
Simple Alternatives to UserForms
Tutorial: This tutorial covers a few simple ways to show pop-up windows to users that allows you to ...
Excel Forum