Insert options smart buttons

I’m going through a list, checking duplicate values. When I need to insert a row, a button keeps popping up asking about formatting.┬áIts dead annoying as it covers up the next values i need to check:

Screen Shot 2016-04-28 at 10.48.15

To turn it off, go to “Excel > Preferences > Edit” then untick the “Show insert options smart button”

Leave a Reply

Your email address will not be published. Required fields are marked *