• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to remove "i" in all cell appearing

Hi,

That looks like Error Checking Marker, you can try disabling some options from:
Excel Option > Formulas > Error Checking Rules

Though it is not recommended.

Regards,
 
Things to try:

1. Check conditional formatting rules.
2. Check for VBA routines.
 
I think those "I"s are the result of a copy paste from the internet. It might be a picture. Thus try this. Select one of those "I"s, then press CTRL+A and press delete.
 
If the "I" are images and looks like they're the only images on the sheet then

Code:
Dim sh as Shape
For Each sh in ActiveSheet.Shapes
sh.Delete
Next sh
 
Back
Top