Removing pictures from Excel file

Office 365 / SharePoint Blog

There is a report that I run out of SharePoint which includes a lot of icons. When I copy the data into Excel, it also copies the icons. I don’t need the icons when I am manipulating the data.

The way to remove all the icons from the spreadsheet at once, I use the Go To command (Ctrl + G), then choose Special, then Objects.

That selects all the images, and the delete or backspace key will remove the images from my worksheet.

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