| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extend formulas
A B
1 Test =LEN(A1) 2 Is there an option setting within Excel 2003 that will automatically write the formula in cell B2 (derived from B1) when I input something in A2. |
|
#2
|
|||
|
|||
|
After you do about 4-6 lines it should start repeating automatically like you
describe. "nc" wrote: A B 1 Test =LEN(A1) 2 Is there an option setting within Excel 2003 that will automatically write the formula in cell B2 (derived from B1) when I input something in A2. |
|
#3
|
|||
|
|||
|
Toolsoptions, Edit tab, check Extend data range formats and formulas. Look
in HELP for details -- Kind regards, Niek Otten Microsoft MVP - Excel "nc" wrote in message ... A B 1 Test =LEN(A1) 2 Is there an option setting within Excel 2003 that will automatically write the formula in cell B2 (derived from B1) when I input something in A2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extend formats and formulas | Excel Discussion (Misc queries) | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Extend data range format and formulas | Excel Worksheet Functions | |||
| extend data range formats and formulas | Setting up and Configuration of Excel | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
