D
dzuy
Is there any way to fill (pattern) a formula in every cell in a column
(without the use of a macro)?
Thanks.
(without the use of a macro)?
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Put the formula in the first cell, select the first cell again and press
ctrl + shift + down arrow to select the whole column, then press Ctrl + d
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
ctrl + shift + down arrow to select the whole column, then press Ctrl + d
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
S
SimonCC
Copy the cell with the formula
Click the column header to select the entire column
Go to Edit | Paste Special, select Formulas radio button and OK
-Simon
Click the column header to select the entire column
Go to Edit | Paste Special, select Formulas radio button and OK
-Simon
D
dzuy
Wow, very nice. Thank you.
Peo Sjoblom said:Put the formula in the first cell, select the first cell again and press
ctrl + shift + down arrow to select the whole column, then press Ctrl + d
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com