In B1 enter the inital balance
In A2 and on down enter your expenses

In B2 enter:
=IF(A2="","",B1-A2) and copy on down

--
Gary''s Student - gsnu2007g


" wrote:

I'm relatively new to Excel and I want to creat a sheet for my
expenses where I can enter a number in one column and have it
subtracted from the above cell in the next column and so on, all the
way down. I can do this by clicking on the bottom left of the cell and
dragging it down but would like it to appear automatically.

Sorry if that's not very clear.

John