Forum Discussion

jodi lawrence's avatar
jodi lawrence
Copper Contributor
Feb 28, 2018

REMOVE multiple picture format boxes

I have a worksheet that I copy  addresses to from another worksheet.  Recently these gray boxes have taken over my worksheet and I have to right click, then cut to remove them off of my worksheet so that I can revise it.

 

When I click on the gray box it appears to bring up the Format Picture Tab however the REMOVE BACKGROUND is grayed out so that is not an option of getting rid of the boxes. 

 

Please tell me how I can clear my worksheet completely of these, possibly all at once. Also can I go into a file that has several worksheets and clear these boxes without compromising my data?

excel
Formulas and Functions
office 365
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 28, 2018

    Hi Jodi,

     

    1. Press Ctrl+G to open Go To dialog box.
    2. Click Special Button to open Go To Special dialog box.
    3. Select Objects and then hit OK.
    4. Now all the objects on the worksheet are selected, so you can press the Delete button on your keyboard to get rid of them.

Resources