Cannot re-drag to do new formula in excel, please HELP

[Luong Ta]

Hi There, I Cannot re-drag to do new formula in excel as I had enter wrong formula before, it has a little grey box at the corner of cell, I can not drag across, please help.
Please see the photo:
25-04-2015 3-03-26 PM.jpg

[Nisha Dhawan]

Hi Luong - Welcome to the Excel Forum.
It seems that you have some shapes on your two cells due to which you are unable to drag the formula. Also, if it is not there, can you please attach the file. Also, the little grey box must be an error message showing (click on that and see).

[Luong Ta]

Formula drag problem.xlsx
Thank you Nisha, it has't got error message just a grey box only. not sure how to attach the file.

[Glenn Kennedy]

Hi there. How annoying for you. You have hundreds of small text boxes (or other shapes) all over your sheet. To get rid of them Hit F5/Special/Objects/OK. Then hit delete and they're GONE.

[Luong Ta]

BIG thank you Glenn, It is really helpful, I am very happy, they are annoying me a lot, thanks again

[Glenn Kennedy]

You're very welcome. Ican sense your frustration coming across the world!! Thanks for the Reputation.

[Nisha Dhawan]

I think I also stated the same in my above post.

Hi Luong - Welcome to the Excel Forum.
It seems that you have some shapes on your two cells due to which you are unable to drag the formula

..