Home | Computers

Entering Data And Editing Cells In Microsoft Excel

By: Andrew Whiteman

Information is entered into an Excel worksheet by modifying the cells within that sheet. The process is pretty much the same regardless of whether you are entering information into empty cells or cells that already contain data. To enter information into an empty cell, simply activate the cell and then begin typing. As soon as you do, the formula bar becomes activated and two icons appeared to the left of the formula bar.

Once you finish typing you may do one of two things: you can either cancel, which will abandon the changes you've made to the cell; or you can confirm the changes you've made. To cancel, you can either click on the cancel button on the left of the formula bar or press the escape key on your keyboard. To confirm your changes, you can either click on the Enter button to the left of the formula bar or press the Enter key on your keyboard.

Pressing the Enter key achieves two things: it confirms your data entry and, usually, moves you down one cell. This is normally fairly convenient. However Excel allows you to decide what actually happens when you press the Enter key. To do so, click on the Office button and choose Excel options. On the left of the dialog box, click the advanced Tab to display "Editing Options". The first Editing Option "After pressing enter move selection" allows you to specify the direction in which you will move whenever you press the Enter key.

You have two options: either choose a direction ("down", "right", "up" or "left"); or, simply deactivate the movement. This will mean that, whenever you input data and press the Enter key, the information goes into the cell but the cell stays active and you don't move down one cell.

If you want to enter data into several cells, Excel allows you to highlight a range of cells and then to navigate between the highlighted cells, entering information as you move. For example, if you are filling out an invoice, you can select a matrix of cells under the "quantity", "description" and "unit price" columns. After you've entered the quantity, you can then press the Tab key on the keyboard to move to the "description" column. You then press Tab again to move the "price" column, and so on.

When we reach the last column of our selection, pressing Tab again moves us to the second selected row. When we reach the bottom right of the selection, if we continue to press Tab, we are taken back to the top left once more. Excel even allows us to move in reverse by pressing Shift and Tab keys together.

There is an alternative to moving right and then down. We can move down first and then to the right by pressing the Enter key instead of the Tab key. Also, pressing Shift and Enter together allows us to move in reverse, i.e., up and then to the left.

There are two ways of inputting information into a cell that already contains information. Firstly, you can simply type a new value. Activate the cell; type the value and then press the Enter key. Secondly, you can edit the value, either by double-clicking on the cell and making your changes directly within the cell; or by activating the cell and making your changes in the formula bar.

Article Source: Main Articles

The The writer of this article is a training consultant with Macresource Computer Solutions, an independent computer training company offering Microsoft Excel training courses at their central London training centre.

This article may be reproduced wholly or in part without written permission provided the byline, resource area, and any hyperlinks remain in order to give proper credit to the author.

Internet search engines and directory listings are imperative to your sites existence and success. Submit Your Website to the Searchen Networks directory and search engine to achieve authoritive inbound links.

Please Rate this Article

Click the XML Icon Above to Receive Computers Articles Via RSS!

Additional Articles From - Home | Computers

	Print This Article
	Post Comment
	Add To Favorites
	Email to Friends
	Ezine Ready

	Submit Articles
	Member Login
	Top Authors
	Most Popular Articles
	Submission Guidelines
	Ezine Notifications
	Article RSS Feeds

	New Stuff
	About Us
	Link to Us
	Contact Us
	Privacy Policy
	Terms of Service

:: Top Author Businesses:

Try your luck, Play BlackJack

:: Our Supporters:

Entering Data And Editing Cells In Microsoft Excel

Why should we use the PPC model for search engine placement?