Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|