Foramulas
 

I have a worksheet that is used to keep softball stats. It already has all
of the formula inserted. My problem is that it only allows for 15 games and
we are already into #13. If I insert new rows the formulas are not there.
Is there a way to format the new rows for each girl so I don't have to
manually go in and retype each new formula with the correct cell/row number.
Any help would be greatly appreciated.
Thanks

Foramulas
 

Insert a blank row where you need it.
Then copy an existing rows and paste it into the new row.
This will copy any formulas in the existing row into the new row.
--
Gary''s Student - gsnu200793


"Candilg" wrote:

I have a worksheet that is used to keep softball stats. It already has all
of the formula inserted. My problem is that it only allows for 15 games and
we are already into #13. If I insert new rows the formulas are not there.
Is there a way to format the new rows for each girl so I don't have to
manually go in and retype each new formula with the correct cell/row number.
Any help would be greatly appreciated.
Thanks

Foramulas
 

If I understand your question correctly, select all the cell in the row for
Games #15 that have formulas in them, then click on the small, black square
located in the bottom right corner of the selection and drag it down for as
many rows as you think you will need, then release the mouse button. If you
check any of the cells with formulas in the rows you dragged into, you will
see the formula with all relative addresses updated for the new row
(absolute addresses will not have changed). Is that what you are looking
for?

Rick


"Candilg" wrote in message
...
I have a worksheet that is used to keep softball stats. It already has all
of the formula inserted. My problem is that it only allows for 15 games
and
we are already into #13. If I insert new rows the formulas are not there.
Is there a way to format the new rows for each girl so I don't have to
manually go in and retype each new formula with the correct cell/row
number.
Any help would be greatly appreciated.
Thanks

Foramulas
 

Thank you so much. That fixed it and helped me greatly.

"Rick Rothstein (MVP - VB)" wrote:

If I understand your question correctly, select all the cell in the row for
Games #15 that have formulas in them, then click on the small, black square
located in the bottom right corner of the selection and drag it down for as
many rows as you think you will need, then release the mouse button. If you
check any of the cells with formulas in the rows you dragged into, you will
see the formula with all relative addresses updated for the new row
(absolute addresses will not have changed). Is that what you are looking
for?

Rick


"Candilg" wrote in message
...
I have a worksheet that is used to keep softball stats. It already has all
of the formula inserted. My problem is that it only allows for 15 games
and
we are already into #13. If I insert new rows the formulas are not there.
Is there a way to format the new rows for each girl so I don't have to
manually go in and retype each new formula with the correct cell/row
number.
Any help would be greatly appreciated.
Thanks

Foramulas
 

Are you very familiar with forumlas to keep a running balance after
expenditures?
Brenda

"Candilg" wrote:

I have a worksheet that is used to keep softball stats. It already has all
of the formula inserted. My problem is that it only allows for 15 games and
we are already into #13. If I insert new rows the formulas are not there.
Is there a way to format the new rows for each girl so I don't have to
manually go in and retype each new formula with the correct cell/row number.
Any help would be greatly appreciated.
Thanks