If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula Extend in Excel 2007
I have a fairly simple spreadsheet in Excel 2007. As data is entered into a
new row, some of the formulas from the previous row automatically extend into the new row (which I want), but some do not. Why is this? Thanks, Dean |
#2
|
|||
|
|||
Formula Extend in Excel 2007
You have an option In XL2007: OfficeButtonExcel OptionsAdvancedUnder
'Editing Options''Extend data range formats and formulas'. For this to work excel would need a minimum of 4 rows on top filled with identical formulas.. You can uncheck to turn it OFF If this post helps click Yes --------------- Jacob Skaria "Deano" wrote: I have a fairly simple spreadsheet in Excel 2007. As data is entered into a new row, some of the formulas from the previous row automatically extend into the new row (which I want), but some do not. Why is this? Thanks, Dean |
Thread Tools | |
Display Modes | |
|
|