Looking for some help..

Is there any way Excel can auto complete formulas horizontally?

Say i want to show the sum of a coloumn on the bottom row. How can i do this without having to drag the formula 300 cells??

When the issue is vertically, one can just double click in the low right corner of the first cell.

Did you guys understand my question?? Hope you did!

Thanx for any answer!