Excel enter: Entering data

Excel enter: YOUR OBJECTIVE

You want to prepare an overview that presents the sales figues for different product groups. To do this, you need to enter information into different cells of the Excel table. There are several options for moving from one cell to the next in Excel.

In this learning module “Excel enter” you will learn how to enter data in Excel and how to move from one cell to the next.

 Excel enter: HOW DOES IT WORK?

When you are preparing a new workbook or table in Excel, A1 is always the active cell. The active cell refers to the cell which is highlighted by a bold border. You can also see which cell is active in the name field below the Ribbon.

You have two options for entering your data:

Place the cursor in the cell, A1 for instance, and enter the data directly here.

Use the formula bar to enter the data. Be careful that the correct cell is activated. You can check this in the name field.

There are many options for completing the entry and moving to the next cell:

  • Press [Enter] to move to the cell below the current cell.

  • Use the [Tab] key to move to the cell to the right of the one just processed.

  • Use the arrow keys , , or  , to complete your entry. The active cell will be moved in the direction of the arrow.
  • Place the cursor in the next cell.

Once the new selected cell is indicated with a frame as the active cell, you can continue entering your data.

HINT

Do not get annoyed if your entries do not currently fit inside the cells. You can widen columns in Excel to improve readability. You will learn how to do this in the Customize row height and column width learning module.

Did you like it? Then share it or sign up!

You can share this article with your friends or sign up for our newsletter for further information.

Leave a comment

Connect with Facebook

*

Kein Banner zum Anzeigen