2. select row header of row 10, go to Insert tab
3. click insert row below, it inserts row successfully after row 10, it adjust formulas of row 12, and other rows there after which is good.
4. But issue is - it neither keep format of row 10 in new row & nor it add formulas to various columns in new row(e.g. F11, E11)
Please suggest how can we achieve it, it is very common and useful feature which excel have. if you do not have any ready solution then please suggest workaround for the same as it is urgent for my client.