| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I automatically extend formulas to added lines in Excel 20
Thanks again - I'll give that a try.
"Jim Rech" wrote: I'm still stumped. Me too. I guess I'd have to see the worksheet or a snippet of it that has the problem. MS did document how auto extend works if you want to sleuth further: http://support.microsoft.com/kb/231002/ -- Jim "BillyV" wrote in message ... | Thanks very much. I've actually had that happen in the past after I entered | data, and didn't know why. But I am working on a new spreadsheet, and | nothing I try seems to extend the formulas, even entering data - I'm still | stumped. | | Bill | | | "Jim Rech" wrote: | | Should this happen automatically? | | Yes it should. But it doesn't happen when you insert the row, but rather it | happens after you enter the data in the new row. | | -- | Jim | "BillyV" wrote in message | ... | When I add new lines to expand a worksheet, existing formulas do not | extend | to the new lines. I have the Tools/Options/Edit 'Extend List Formats & | Formulas' box checked. Should this happen automatically? | | | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel file automatically opens - More Info | Excel Discussion (Misc queries) | |||
| Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
| Can Excel 2002 SP3 automatically import RSS data feeds? | Excel Discussion (Misc queries) | |||
| Excel 2002 calcs slower than Excel 97 | Excel Discussion (Misc queries) | |||
| Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions | |||
Threaded Mode
