Maintaining Formulas

[dcontois]

I recently downloaded a check register template. It gave me 89 lines of
entry. When I go beyond that and need to add more rows, it loses the
formulas. I am not proficient obviously with Excel, just want to maintain a
check register on my computer.

 

[trip_to_tokyo]

You need to copy the formulas to the rows below row 89; this should work OK.

Please hit Yes if my comments have helped.

Thanks.

 

[dcontois]

Okay, but do I have to change the row # for each row? Do I need to continue
to copy the formula for every row I add. This could get tedious.

 

[dcontois]

I can't even seem to copy the formula.

You need to copy the formulas to the rows below row 89; this should work OK.

Please hit Yes if my comments have helped.

Thanks.

 

[trip_to_tokyo]

If your formula is in cell A1 (for example):-

1. Do a Ctrl-C in cell A1 to copy the cell contents.

2. Then highlight the cells to which you want to copy the formula (say, for
example, cells A2 to A5 inclusive).

3. Then do a Ctrl-V to paste the formula to the destination cells (A2 to A5
in my above example).

So you can do the copy and paste very easily and quickly over a range of
cells.

Please hit Yes if my comments have helped.

Thanks.

 

[trip_to_tokyo]

Click in the cell whose formula you wish to copy.

Do a Ctrl-C (to copy the cell contents).

Are you there now?

Hope so.

Please hit Yes if my comments have helped.

Thanks.

 

[dcontois]

Okay, but do I have to change the row # for each row? Do I need to continue

to copy the formula for every row I add. This could get tedious.

I got the formula to copy but it seems the row #'s have to be manually
changed to the correct #.

 

[dcontois]

=IF(AND(ISBLANK(F97),ISBLANK(G97)),"",H95-F97+G97)

This is my formula. Where the H95 is it should be H96. When I copy and
paste it it is always 2 rows behind.

 

[dcontois]

I think I finally have it. Thank you for helping this Excel challenged person.

 

[trip_to_tokyo]

OK, great, happy to have been of assistance.

I think I finally have it. Thank you for helping this Excel challenged person.