| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using a formula for a column or range
I am trying to do a spreadsheet with this funtion
=A1*D1 and not type this in 900 times ex: =A1*D1 =A2*D2 =A3*D3 ETC ETC. i'm sure this is an easy one for someone. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using a formula for a column or range
Type A1*D1 into the cell, press enter, select the cell again, move the
cursor to the lower right corner of the cell and click and hold the left mouse button, then just drag the formula down to wherever you want it to stop and the formula will change with each row -- Regards, Peo Sjoblom "lks1" wrote in message ... I am trying to do a spreadsheet with this funtion =A1*D1 and not type this in 900 times ex: =A1*D1 =A2*D2 =A3*D3 ETC ETC. i'm sure this is an easy one for someone. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using a formula for a column or range
Thank You very muchh
"Peo Sjoblom" wrote: Type A1*D1 into the cell, press enter, select the cell again, move the cursor to the lower right corner of the cell and click and hold the left mouse button, then just drag the formula down to wherever you want it to stop and the formula will change with each row -- Regards, Peo Sjoblom "lks1" wrote in message ... I am trying to do a spreadsheet with this funtion =A1*D1 and not type this in 900 times ex: =A1*D1 =A2*D2 =A3*D3 ETC ETC. i'm sure this is an easy one for someone. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to take average from column range matching another | Excel Discussion (Misc queries) | |||
| formula to match a range(sort) so it matches an external column | Excel Discussion (Misc queries) | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| I need a formula to find rows within a date range in one column? | Excel Worksheet Functions | |||
| how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
Hybrid Mode
