| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert row adds formula to cell
For one way, take a look he
http://www.mvps.org/dmcritchie/excel/insrtrow.htm In article , Johnny G wrote: I have a hidden column with a similar formula in each cell. For example cell B2 is "=month(A2)", B3 is "=month(A3), etc. There are time when a row has to be inserted, and since the B column is hidden from the end user I would like to automatically add the formula to the cell added in the B column. Hope that is easy to follow ;) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel example-formula C4+C5 adds before data in C5 Can I get it t. | New Users to Excel | |||
| Date formula that adds 7 days to a cell when sheet is copied | Excel Worksheet Functions | |||
| NEED A FORMULA THAT ADDS EVEN OR ODD ROW NUMBERS | Excel Worksheet Functions | |||
| Make a formula that adds every 4th cell in a column indefinately? | Excel Worksheet Functions | |||
| Formula which adds together worksheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
