can follow line above when insert new row?

[choy96]

Every time insert the new row on certain workbook, the line is gone, but some workbook still can follow the line as above. I think it should be the setting wrongly. can help?

thanks

[Marcol]

With your example sheet as it stands

1/. Delete Row 11
2/. Select Row 10 and > Insert Row
3/. Select Row 11 and > Insert Row...etc

Always select the last row in your grid, and Excel will copy that format and move the cells down.

Hope this helps

[choy96]

after delete the Row 11, then select row 10 to insert row, line still not appear. why?

[Marcol]

Are you deleting the entire row using the menu selection Delete Row?

Using the keyboard delete will not delete the row, only clear the contents.

[choy96]

i press the key Ctrl and - , then select entire row to delete the row. After that, select Ctrl and + the add a new row. Have i mistake?

[Marcol]

Hmmm...?

I never knew these combinations of keystrokes.

I tried them as you described, with your sample workbook and they worked for me.