|
||||||||
       |
|
|||||||
|
|
» Getting Started with Microsoft Excel - Entering and Editing Data
| Entering Data |
As discussed before, data is entered by selecting a cell and entering data. In the illustration below, if you wanted to enter the year column (column A) you would click on cell A2, type 1997 and press [ENTER]. Entering the data would automatically advance the active cell to the next row or cell A3.
The reason A2 was chosen as the first cell to start entering the year labels is to allow a row (row 1) to be used for headings of each of the columns. Subsequently, columns B, C, D, etc., were entered. This was done by first entering the column heading, e.g., Net Income, and then the values 80000, 78900, 67800, etc. Note the values entered were "plain" numbers such as 80000 instead of the formatted number $80,000.00. It is important to enter the number as a plain number and format the cell to the required specification. We will do this in a later section of this tutorial.
| Editing Data |
Once you have entered data into a cell, that data can be edited by first clicking on the cell to make the cell active and then clicking on the formula bar above the worksheet. This allows you to insert or delete characters in that cell. An alternate method of editing the contents of a cell is to click on the cell to make it the active cell and then press the [F2] function key at the top of the keyboard. You can delete the contents of a cell by clicking on the cell and pressing [Delete] on the keyboard.
| Inserting Columns, Rows and Cells |
To insert a column, click on the column you wish the new column to appear ahead of or to the left of and click Insert on the menu bar at the top of the screen. Selecting an existing row to insert a new row ahead of or above is done the same way. Once you have selected Insert on the menu bar at the top of the screen, you can click Columns to insert a new column or Rows to insert a new row. You can experiment inserting new columns, rows and cells. You will notice that when requesting a new cell, Excel asks if you wish to move the existing cells to the right or down.
Continue to next page >>
| Quick Tutorial Navigator » The Worksheet and Cells » Entering and Editing Data » Working with Formulas » Formatting the Worksheet » Creating a Chart » Printing the Worksheet » Saving the Worksheet » What Next?
|
• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books
Terms
and Conditions of use |
|
|
Copyright © 2003 ExcelTip.com | |