If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I add a formula to a range of cells
|
#2
|
|||
|
|||
How do I add a formula to a range of cells
1) You can type a formula into a cell and then drag the that cell's fill
handle (solid square in lower right corner) to fill other cells with the formula. You need to know about absolute and relative referencing - see Help I the cell is part of a vertical table, double clicking the fill handle is quicker than dragging it. 2) You can select a range of cell, type the formula and finish off with CTRL+ENTER. This fills the selected range with the same formula - with appropriate cell reference changes. best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "wotnow" wrote in message ... |
Thread Tools | |
Display Modes | |
|
|