My formula is =H3-F6+I6

H3 contains my starting balance.

H Column labeled Balance

F Column labeled Debit

I Column labeled Credit


If the Balance is for example $1000, all of the rows below the last entry
show $1000 in the Balance column. I would like to duplicate the way an
actual checkbook register looks and have nothing displayed in those rows
until I input a debit or credit. How can I do that?