Avatar of Stephen Kairys
Stephen KairysFlag for United States of America

asked on 

Excel 2016 - Cannot get rid of prompt per formatting after inserting row

Excel 2016/Win10

Hello again,

After I inserted a row in a spreadsheet, a prompt (see below) appeared on the screen as follows. (The "Check sequence..." is part of my data...)
User generated image
Even after I choose one of the options, the prompt remains. (Excel may be "confused" b/c a nearby row is formatted with a yellow background and its cells are merged.). How can I get rid of it?

Microsoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
Anastasia D. Gavanas
Avatar of Stephen Kairys
Stephen Kairys
Flag of United States of America image


By the time I entered this question, went to another open workbook and came back the prompt was gone, with no logical explanation.

For future reference: how I can I get rid of it without "having to wait"? :)

Thanks again,
Avatar of Anastasia D. Gavanas
Anastasia D. Gavanas
Flag of Greece image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Disable the feature by using suggestion 2 in my previous comment if you don't want to have this ever :)
Avatar of Stephen Kairys


Just to be clear, the problem occurred right after I inserted the row and before I pasted. Would the above still apply? Thanks!
yes, I tried it exactly like you described...had a formatted row, inserted a row and got the insert options you mentioned...I discabled it (Excel 2016) and now I repeat the same stems and do not get those options button :)

Now if you copy-paste, you will still get the paste options button (different from what you have in the image) but that goes away by pressing Esc and you may want to keep that :)
Avatar of Stephen Kairys


I went with:
>>3) Paste again somewhere else and undo (workaround but it works for me).

NOTE: I did not try the other two solutions. For one thing, I may find this prompt useful at some point.

Thanks for the prompt (if you pardon the pun :) ) and informative replies!

No problem!  Glad I could help :)
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo