Excel - White spots what is it?

[Baymax9]

Hi i was given an Excel template by somebody to use and when i look closely, near the top of the page there is some white item/spot.
I cannot click on it until i zoomed the page to the max, and when i finally clicked it, it showed white box with absolutely nothing to click at. (picture attached)
I can’t delete or do anything to it. Can someone help me

to figure what it is and what can i do to delete it?
Image: Excel white spot - Imgur

 

[oldbrewer]

See if it is some kind of header

 

[steve the fish]

See if its an object. Press Home-Find and Select-Select Objects. Select the cells around the object. You must completely enclose it. Press delete. If it is an object it will be gone.

 

[oldbrewer]

make a copy of the spreadsheet - is it still there ?

 

[Baymax9]

Hi guys, thank you so much for the suggestions!

See if its an object. Press Home-Find and Select-Select Objects. Select the cells around the object. You must completely enclose it. Press delete. If it is an object it will be gone.

Select Objects lets me select the object however i still cannot delete it. Instead I have tried to click Selection Pane and i finally found that it is an object (i can show/hide all objects and narrowed it down). However i still cannot delete or do anything to it.

Any further suggestions?

 

[Norie]

What happens if you go to Find & Select>Go To Special..., select Objects and then press Del(ete)?

 

[Baymax9]

Dear Norie, it solved the problem! however it also deleted all of my objects which i do not wish to do. And if i select just that object, it won't delete. hmmm??

 

[Baymax9]

Hi guys, actually i went to Developer Mode -> Design Mode and deleted it finally! It was an EMBED ComboBox apparently!

Now everything is fine. thank you all for the advice!

 

[Norie]

What happens if you run this code?

Sub ListStuff()
Dim ws As Worksheet
Dim wsList As Worksheet
Dim rngList As Range
Dim obj As Object

    Set wsList = Sheets.Add

    wsList.Range("A1:B1").Value = Array("SheetName", "ObjectName")

    Set rngList = wsList.Range("A2")

    For Each ws In ActiveWorkbook.Sheets

        If Not ws Is wsList Then
            For Each obj In ws.Shapes
                rngList.Value = ws.Name
                rngList.Offset(, 1).Value = obj.Name
                Set rngList = rngList.Offset(1)
            Next obj

            For Each obj In ws.OLEObjects
                rngList.Value = ws.Name
                rngList.Offset(, 1).Value = obj.Name
                Set rngList = rngList.Offset(1)
            Next obj
        End If
    Next ws

End Sub

 

[Baymax9]

Hi Norie actually i have solved it as i explained in my post above.

But thanks so much for the effort above!! Truly appreciate it. this forum is awesome!!