Rightmost Column won't auto-fill like all the others.

  • Thread starter Thread starter SharonSmith
  • Start date Start date
S

SharonSmith

I want a very simple check register type Budget sheet. The balance is the
rightmost column so the balance = H3-G4. As I enter the first row of
calculations Qty * Cost, + Tax & Shipping & Extended Cost, all these rows
automatically calculate on the next row, but the Balance never does. I must
click/drag from row above to get it to populate the bottom row. Why? What
can I do to get that last column to auto fill?
 
I'm not sure why it won't extend the formula in that column. The
following MSKB article explains how Auto Extend works:

XL2000: How Auto Extend List Behavior Works
http://support.microsoft.com/?id=231002

but your formula doesn't seem to violate any of the autoextend rules.

You could tab to that column and press Ctrl+D, to copy the formula from
the cell above. Or, after you've done the day's entries, select the last
filled cell in the balance column, and double-click the fill handle, to
copy the formula down to the last row of data.

Or, use Excel's built in data form (Data>Form) to enter the data. It
will fill in all the formulas for you. Or download John Walkenbach's
Enhanced Data Form. It's a free add-in, allows combo boxes, inserts new
rows with formulas, and has unlimited fields.

http://j-walk.com/ss/dataform/index.htm
 
Back
Top