Adding Calculation to all cells in a column

Hello!

I want to add a calculation to all cells in a column instead of typing it in for each one. How can I do this easily?

Thanks,
Kevin

Ok Great! The Cntrl D works. Not sure how to code it with VBA.

Kevin

You can also use the auto-fill feature.

After entering the formula in the first applicable row, hover your mouse pointer over the little box in the bottom-right corner of the cell. The pointer should change into a plus sign.

Then just double-click and the formula will be auto-filled down the entire column.

Both of those suggestions worked great and saved me a ton of time! THANKS!

Glad we could help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.