Ungroup

Hi Harry,

Thank you for your post. I've applied grouping to some rows of data in my Excel sheet. I was able to insert a new row when I right-clicked on a row header and then clicked on "Insert".

If it still doesn't work on your side, check for other settings such as freeze panes or filters running. Turn these off as they may interfere with certain other settings. Also check for protection, merged cells or hidden rows.

I hope this helps.

Kind regards
Marius Barnard
Excel Trainer