 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Extend Formula not working
Using Excel 2003 and have put a check mark next to the box to "extend data range formats and formulas." I then began entering data and created a formula in Column E that calculates a running balance based on whatever is entered in the row. When I first built the worksheet, I copied the formula that I entered in Row 3 down four more rows and filled in those four additional rows with current data. Now that I have gone back to that worksheet to enter new data in the next row, but the formula does not seem to automatically extend to the new row. I entered data in the row and whether I tab to Column E or arrow over to Column E, my new balance does not appear. I thought the formula was supposed to automatically extend to the new row of data. What step did I miss? This works. In E1 enter =SUM(A1:D1) Copy down at least 3 rows so you have 4 rows in total with the formula. Enter data in A5:D5 and the formula in E1 will "extend" Data must be entered in all 4 columns A:D in order for the formula to extend. Gord Dibben MS Excel MVP >Using Excel 2003 and have put a check mark next to the box to "extend data >range formats and formulas." I then began entering data and created a [quoted text clipped - 10 lines] > >What step did I miss? This is a simple check register for my children. Column A is a date. Column B is the payee name. Column C is the description of what the payment is for. Column D is the amount. Column E is the running total of the balance. So in Row 3 I entered =E2-D2. I copied that formula down four rows to be able to enter current information. When we went back in today to enter a new expenditure, the running balance cell in Column E did not update. > This works. > [quoted text clipped - 24 lines] >> >>What step did I miss? Hi BK, FYI - from the help system: Extend list formats and formulas Select to automatically format new items added to the end of a list to match the format of the rest of the list. Formulas that are repeated in every row are also copied. To be extended, formats and formulas must appear in at least three of the five last rows preceding the new row. Cheers, Shane Devenshire Microsoft Excel MVP > Using Excel 2003 and have put a check mark next to the box to "extend data > range formats and formulas." I then began entering data and created a [quoted text clipped - 10 lines] > > What step did I miss? I read that same information in the help, so I copied my original formula down four rows when I first entered it. Now today when I added a new row of data, that formula in Column E did not calculate anything at the end of the new row of information. > Hi BK, > [quoted text clipped - 24 lines] >> >> What step did I miss? It can be switched on/off in Excel Options best wishes  SignatureBernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email >I read that same information in the help, so I copied my original formula >down four rows when I first entered it. Now today when I added a new row [quoted text clipped - 29 lines] >>> >>> What step did I miss? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.