| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I add a formula to a range of cells
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| Formula on a dynamic range of cells | Excel Discussion (Misc queries) | |||
| formula to find a range of cells = to a value | Excel Worksheet Functions | |||
| how to use the IF formula with a range of cells | Excel Discussion (Misc queries) | |||
| Formula help for using a range of cells! | Excel Worksheet Functions | |||
Linear Mode
