excel cell format without change

[johncena]

dear friends in my document different columns i have selected different cell formats.if i inset new rows that new row cells format not equal to my before settings.how i can manage this.that new inserted row cells also i need my before format setting.pls help me.

[pike]

hi johncena
You can add the format to the new row by copying the format below and special pasting formats