Removing all images in Word or Excel

Office 365 / SharePoint Blog

Sometimes when copying information from a SharePoint page (or any website for that matter) to an Excel or Word document, you can end up with images that you don’t want. You could click each of the images and hit DELETE to get rid of them, but here is a faster way:

In Excel

Use the Go To command (Ctrl + G), then choose Special, then Objects.

The delete and backspace keys will remove the images from your worksheet.

In Word

Open the Find & Replace tool (on the PC, it’s Ctrl+H)

To remove all images at once, place ^g in the find field, leave the replace field blank, and then choose Replace All

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s