# How to add formula for whole column microsoft excel

> To add a formula for a whole column in Microsoft Excel, first open the file you wish to edit. Next, click the bottom-right corner of the cell and drag it to the desired range. Finally, release the mouse to automatically fill the cells based on the copied formula.

Canonical: https://livedemo.ai/tutorials/how-to-add-formula-for-whole-column-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2dced673bd5aa8e5f91d/preview?step=1

## Steps

1. Open the file you wish to edit on MS Excel.
2. Open the file you wish to edit on MS Excel.
3. Click the bottom-right corner of the cell and drag it to the range where you want to copy the formula.
4. Release the mouse, and the cells will automatically fill based on the formula you copied.