Automatic formatting when inserting rows

Question

I have set a row with certain borders/merged cells/font/colors, etc. I would like for when I insert a new row below this row to continue using this formatting I set above. I have played around with the wooksheet and it seems like only some cells do this and others don't. How/why does this do this and how can I make sure I can have the correct formatting be copied down when I insert a new row?

Thanks

Answer 1

Hi,

Does it happen with a particular file or with all the files?

Create a new test file and check if it works as expected.

If this works, then you may copy the contents of the problem file to a new file and verify the results.

Answer 2

I have a similar problem.  I have a spreadsheet with simple formulas in the columns, but when I insert a row in some areas of my spreadsheet, the formulas in the columns do not automatically appear in the new row.  There are other areas within the same spreadsheet where I can insert a row and the formulas automatically appear in it. I cannot figure out what is the source of this inconsistency.  My end spreadsheet has to be something others can insert rows into without having to do any special formatting on their part.  Thanks.

Answer 3

Hi,

As I understand you are facing issue working with the Excel formatting.

How are you inserting the new rows?  Does it happen with a paricular file or with all the files?

Have you tried using the Format Painter?

You can use the Format Painter from the Home tab so that the same formatting is applied in the workbook and check if it helps.