Moving Total row down as I input

  • Thread starter Thread starter rushd45
  • Start date Start date
R

rushd45

Hello,

I'm fairly new to excel. I have created a worksheet 'expenses to build my
house', where I input the info. There were originally 30 rows, I am at 60
now and can copy and past the rows to create more, but I lose the total if I
have lots of rows. Is there some way to just enter the info needed on each
row and at the return the total line is kicked down automatically to the
next row?

Also how can I see in a bar graph the $ spent for the different column
headings?

TIA
Rush
 
rushd, here's how you might set up your worksheet: leave one blank row at
the bottom of the column and in the next row down enter the SUM function. Be
sure that the sum includes the empty cell in the range it references. Then
follow this procedure to add new items:

To add one item, right-click the empty cell immediately above the SUM
function and select Insert > Shift cells down > OK. Enter the new item in
the empty cell two cells above the SUM and the SUM will update
automatically.

To add more than one item, highlight a number of cells equal to the number
of items you want to add, starting with the empty cell above SUM.
Right-click the cells and Insert > Shift cells down > OK.

Note that you will always leave that blank row between the last item in the
column and the total, and that the SUM function must include that blank row
in the cells it references.

One easy way to create a chart: If your data is all together, click any cell
in the data and press F11. If your data isn't all together, select the data,
then press F11.
 
I normally put the totals/calculations/summaries at the top to avoid that
problem, and just make the formulas extra long, e.g. SUM(A10:A9999). I then
select the row under the calculations/summaries and freeze the pane there,
if I need it visible while I'm scrolling around.

You might also try, rather than copy/pasting new rows in, to INSERT rows
WITHIN your range (not under it) --, which will expand the formula
automatically and will move the running total down.
 
Back
Top