Each cell can hold "one thing"
To select a single cell you could do either 1 or 2 below:
Point a using the mouse, and click on it.
A darker border appears around the selected cell.
To select a range of cells you could do either 1 or 2 below.
To copy the contents of a cell, you could do it in any of the following ways.
Each cell (the area where a column and a row intersects) has a name.
The name is the column and
row designation for that cell i.e. A1 or D25.
The name of the cell that is selected is shown in the
Name Box on the editing tool bar.
You can enter a number, a label (aphanumeric characters, or a formula in a cell.
You can also enter
a macro (a programmed sequence of events) in a cell, but we will not be covering any programming
A group of cells that are selected together is called a range.
A range of cells make up a rectangle.
range may be only in a column or a row or a combination.
The range in Excel is always expressed as
the top left cell, then a colon, and then the bottom right cell.
A1:A20 would contain all the
cells in the A column from row 1 through row 20.
A1:M1 would contain all the cells in the columns A,
B, C, D, E, F, G, H, I, J, K, L, & M and in row 1.
A1:E20 would include all the cells in columns A
through E and rows 1 through 20.
There are always several ways to use any feature in Excel.
You goal should be to use the
way that allows you to work most efficiently i.e. quickly!
Many students who have grown up
using the PC to surf and are therefore overly mouse dependent -
Many times you can use the
keyboard - especially if you are inputting data more efficiently if you use the keys on the keyboard
instead of the mouse.
Note most, but not all the things that you can do with the mouse, you can do
with the keyboard.
Use the arrow keys on the right side of the keyboard to move the cursor to the cell.
border appears around the selected cell.
These are the arrow keys between the alphanumeric keys and the number pad.
It is best to
leave the NumLock on when using Excel as the number pad on the right side of the is generally the
quickest way to enter numbers and the basic mathematical operators.
When a range is selected there is a darker border around all the cells and there is a small
black box in the bottom right hand corner of the border around the range.
This small black box is
often referred to as a " handle ".
1. Point at the first cell with the mouse and click on it to select it.
While pointing at the first cell (top
left cell) in the range, hold down the left mouse button and drag the cursor to the last cell (the bottom
right cell) in the range and then release the mouse button.
2. Using the arrow keys, select the first cell (the top left cell) of the range. Hold down the shift key and