The shortcut keys (Ctrl + C), (Ctrl + X) and (Ctrl + V) correspond to copying, cutting and pasting data respectively and are consistent with other applications. It will only get replaced with a subsequent Cut or Copy command. The data will stay there until it is replaced by some other data. Whenever you copy cells, Excel stores the data in a temporary memory called the clipboard. There are a large number of shortcut keys that can help you to select data and probably the most useful is (Ctrl + Shift + 8) which selects the current region.
To deselect a cell or range of cells click anywhere outside the range or press any of the arrow keys. If a range of cells in selected then the active cell is identified as white. When a range of cells is selected, only the upper left cell is considered to be the active cell. The address of the active cell is always displayed in the "Name Box" to the left of the Formula bar. The active cell is always surrounded by a black border. There can be a number of cells selected on a worksheet at any one time but there will only ever be one Active Cell at any one time. If you are not able to edit the contents in the cells directly then check your (Tools > Options)(Edit tab, "Edit directly in cell").īefore you can enter data into a cell you must select the cell first. You can enter (and edit) the contents of cells either by using the formula bar or by using the cell directly. If you select a cell and start typing you will over-write the contents of that cell. Text entries are considered to be labels because you cannot perform any calculations on them.įormulas - These all start with an equal sign (=) and allow you to perform mathematical operations. These are also known as labels or strings. Text - These are basically words or any kind of text data. This allows dates and times to be manipulated within formulas such as adding and subtracting dates.
#MICROSOFT EXCEL SHIFT CELLS UP SERIAL#
This includes dates and times which are treated as serial numbers. Numerical - These are basically numbers or values. This is sometimes expanded to four as some people class Dates & Times as a separate type. You can enter three different types of data into cells. These are ranges of cells that are not in a nice rectangular block. Multiple cell ranges are commonly known as non adjacent or non contiguous ranges. The space is also known as the intersection operator.
If not then an error message will appear. When you use this operator the two blocks of cells must overlap. Space ( ) - This is used to combine the intersection of two blocks of cells (e.g. The comma is also known as the union operator. A range of cells is described in terms of the top left cell and the bottom right cell references separated by a colon.Ĭomma (, ) - This is used to define non adjacent cells (e.g. The colon, comma and the space.Ĭolon ( : ) - This is used to define a range of cells (e.g.
There are three types of cell reference operator that can be used to identify cells and ranges. This is often referred to as the Cell Address.Īll the cells on a worksheet are separated by grey lines, known as gridlines and a group of adjacent cells is known as a Range of cells. The location of a cell on a worksheet is given by its column letter and its row number (e.g.
0 kommentar(er)
