How to Add Formula for Whole Column Microsoft Excel

‍

‍

Here's how to do it:

‍

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.