how to get rid of the autofill box that pops up

[oddcarout]

Ok so when I have a cell highlited and clickhold the little box on the bottom right and drag to include more cells this stupid little box shows up on the right. Well it covers the info I am looking at simultainiously. I want it gone.

How do I make it so that it does not ever come up?

Thanks

[oldchippy]

Hi,

Is it a little box like this that pops up?

http://www.contextures.com/xlDataVal04.html

[shg]

Are you talking about the stupid AutoFill Options box or another stupid box?

[oddcarout]

yes the options box.

It is blue and when you click on it you get three radio button options.

Thanks

[shg]

Tools > Options > Edit, uncheck the stupid Show Paste Options buttons.

[oddcarout]

one more.

I have numbers formatted as text and get the popup box on the left telling me there is a problem. i have not figured out if there is a way to get rid of that one also.

thanks