|
||||||||
       |
|
|||||||
|
|
» Getting Started with Microsoft Excel - The Worksheet and Cells
Microsoft Excel is a spreadsheet application. Most of the work performed in Excel is done on a worksheet which is a grid of rows and columns. The rows are numbered along the left of the grid while the columns are headed by letters along the top. Each intersection of a row and a column is called a cell and has a unique reference identifying it. For example, the cell where column B and row 5 intersect is cell B5. Cells are used to store data such as labels and numbers, and cell references are used when writing formulas or referring to cells.
Data is entered into single cells. The cell that has been selected to enter data is called the active cell and is identified by a heavy border. Only one cell can be active at a time.
| Changing the Active Cell |
To change the active cell, move the mouse pointer into a cell and click. For example, in the preceding illustration if we wanted B4 to be the active cell, simply click that cell. Upon selecting B4, the formula bar would display the contents of that cell or 67800. Demonstrated in the illustration above is cell E4 as the active cell and the formula =C4/D4 displayed in the formula bar since the contents of cell E4 is the formula dividing the contents of C4 or $489,000.00 by D4 or $225,000.00.
| Scrolling Through the Worksheet |
There are several methods that can be used to scroll through the worksheet:
- Move the pointer to the down arrow in the vertical scroll bar on the right edge of the window and click. The worksheet scrolls down one row.
- Move the pointer to the right arrow in the horizontal scroll bar on the bottom of the window and click. The worksheet scrolls to the right one column.
- Click, hold and drag either the vertical or horizontal scroll bars. This scrolls through the worksheet for as long as you hold the scroll bar.
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 | |