| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I force formula to be applied automatically?
Hi,
For example, I have a excel sheet with two columns, A and B. B's value is calculated based on A, e.g. =A1+1 My problem is that the formula is only applied to the cells selected. I have to drag it to apply for other cells. Is there a way that when new cell is added to column A, column B will be automatically populated? Many Thanks Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| leave cells blank until formula applied | Excel Worksheet Functions | |||
| how do you force a new line in a formula in Excel? | Excel Worksheet Functions | |||
| blank cell until after formula applied | Excel Discussion (Misc queries) | |||
| How do I define colors that are automatically applied to data seri | Charts and Charting in Excel | |||
| Validation applied to formula result | Excel Discussion (Misc queries) | |||
Threaded Mode
