How do I fill a long Excel column with a formula without dragging it manually?

Filling an Excel column manually with a formula in each cell can be daunting if your column is longer than 100 lines but Microsoft has equipped us with several automatic procedures to make it easy. Below is one solution that I believe is the easiest. Let me know what you think when you have tried it.

Best Solution:

Tutorial - Excel column with Formulas After you have filled all the information in the other columns in your worksheet, type the formula in the first cell of the column in which you need the information generated.

Double click the “fill handle” that you would normally “drag” down and the formula in that cell will be copied into the last cell of that column adjacent to the last cell of the corresponding columns.

For more help with Microsoft Excel sign up for a Remote Assistance Session and I will be on hand to help you when you need it.

Posted in: Excel Formulas, General, Microsoft Excel