I have an excel sheet that was forward to me. I open some and I get a picture, some I get the page but no info

Question

Items are from an auction co. I'm trying to find 1 item. I have 36 items, the 1st 21 open with the picture and the gen.l info that comes with a bid. #s 22-36 pop up as the page, but without the PICTURE or any other info.I have a feeling there is some formating in lines 1-21 and not 22-36 & I can not seem to find the difference. I have sorted, looked at criteria by a different column, inserted a line between 1-21 cut&paste with item 25 & did not work.The page comes up where the picture should be, I click on the red "x" to open picture,& nothing happens. A watch maker stole my watch & I need the picture to show him &his manager. I left 9 watches for minor things &came back in an hour.I did not check the bag until we went home. Rec. has 9 items (not in detail) I've 8 watch. Hubby went there &the same sales was there &he seemed to forget how to speak English with the Mgr there.So I'm trying to find the picture and bring it in. He actually fixed that watch first and put it with the others

Answer 1

I know Excel inside & out...and I would love to help you, but I really cant understand what you are asking for.

So - you are trying to find the picture. OK. Pictures are handled as graphics on a different layer. They are not tied directly to cells or formulas. It should be clearly visible

Try this: select all (Ctrl-A) go to the edit menu, select Clear > Formats. Now, in the format menu, row > unhide, row > autofit, and Column > unhide, Column > autofit.

That should open up your entire worksheet. If something is there, you should see it.