| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert row not coping all forumlas
I have about 100 calculated collums on a row. When I insert a new row, about
70 of the formulas automatically copy into the new row. How do i fix it so all of them copy into the new row? Thx |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert row not coping all forumlas
I know there was a reply to this already but can't see it so...
check out this site http://www.mvps.org/dmcritchie/excel/insrtrow.htm |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert row not coping all forumlas
I had found that already but trying to figure out why some do and some dont.
I also found while doing some sorting that when i sort on collums and tell it to expand selection that not everying is sorted. It appears as if somehow excel has decided that each row is chopped into seperate sections. Need to let it know the entire row is one record. "D." wrote: I know there was a reply to this already but can't see it so... check out this site http://www.mvps.org/dmcritchie/excel/insrtrow.htm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forumlas or scripts? | Excel Discussion (Misc queries) | |||
| how to transpose forumlas | Excel Worksheet Functions | |||
| Forumlas Not Executing | Excel Discussion (Misc queries) | |||
| The best method for forumlas and charts??? | Excel Discussion (Misc queries) | |||
| Help with Commission forumlas | Excel Worksheet Functions | |||
Linear Mode
