Entering Data And Editing Cells In Excel 2007
by: AndrewWhiteman |
Total views: 1 |
Word Count: 561 |
View PDF | Print View
Share This Article
One enters information into an Excel worksheet by modifying the cells within that sheet. The process is the same regardless of whether you are entering information into empty cells or cells that already contain data. If you wish to enter information into an empty cell, simply activate the cell and then begin typing. When you do so, the formula bar becomes activated and two icons appeared to the left of the formula bar.
Once you finish typing you can do one of two things: you can either cancel, to abandon the changes you've made to the cell; or enter, to confirm the changes you've made. To cancel, either click on the cancel button on the left of the formula bar or press the escape key on your keyboard. Alternatively, you can confirm your changes: to do this you can either click on the Enter button to the left of the formula bar or press the Enter key on your keyboard.
The action of pressing the Enter key does two things: it confirms your data entry and, also, moves you down one cell. This is usually pretty convenient. However Excel allows you to decide what happens when you press the Enter key. To specify this, click on the Office button and choose Excel options. On the left of the dialog box, click on the advanced button. This will display "Editing Options". The first Editing Option reads "After pressing enter move selection" and allows you to choose the direction in which you move whenever you press the Enter key.
As well as choosing "down", "right", "up" or "left", you also have the option of completely deactivating the movement. This means that, whenever you make an entry and press the Enter key, the information is entered into the cell but the cell remains active: you don't move down.
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.
As an alternative to moving right and then down, you can move down first and then to the right. To do this, press the Enter key instead of the Tab key. Pressing Shift and Enter allows you to move in reverse: 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.
Share This Article
Rating: Not yet rated Next Article - Excel 2007 Number, Currency And Accounting Formats and Previous Article - Spyzooka Review
About the Author
Author is a developer and trainer with Macresource Computer Solutions, an independent computer training company offering Microsoft Excel Classes at their central London training centre.
Comments
No comments posted.Add Comment
Popular Articles about: Software
1: Viagra2: Adobe Illustrator: Getting Past The Blank Canvas
3: Enhance Your Web Pages With Dreamweaver's Javascript Behaviors
4: How to use a poker software
5: MyCafeCup.com launched new AIO Internet Cafe Software + WiFi HotSpot Gateway Billing.
6: The Easy Way To Write An E-book
7: How to convert swf to Avi, iPod, iPhone, PSP, Zune
8: Optimize Your PC With Registry Cleaner
9: A new version of contextual German-English and English-German dictionary TranslateIt! for Windows
10: Pre-packaged vs. Custom Software
11: Getting Rid Of The This Nasty Philippine Made Virus
12: DOCUMENT SCANNING STORAGE of RECORDS DIGITIZING ARCHIVING PAPERLESS OFFICE NYC.
13: Using Personal Computers to Solve Humanitarian Problems
14: Your Reaction to the Idea of Paying Students
15: The Story of Finding Longitude: It Was All a Question of Timing
16: Choosing the Turnkey Software for your Business
17: Find Home Renovation Software
18: Tokenless Two Factor Authentication Ensures Secure Remote Access
19: The Way People Communicate Has Changed Over Time
20: Windows Vista Ultimate OEM Software
21: How To Safely Clean Windows Registry
22: Commercial Driver’s License CDL Manual
23: Does iBuzzPro Automatic Recruiter Software Actually Work?
24: Management Software To Drive Your Bottom Line
25: Multiple Streams of Income...Surefire Way to Success
26: How to find an email address easily
27: How To Use Article Marketing For Free Unlimited Traffic
28: Big Ticket to Wealth Retail Store-- Is It Worth A Visit?
29: Don't Buy a Myspace Friend Adder: Compare Consumer Ratings First
30: Cleaning Your Windows Registry Effectively