Excel - Select or Delete Multiple Images or Objects in a Spreadsheet - Episode 363
1,312 views · Published 4 November 2009 · 1:43 · Indexed 27 October 2026
Channel: MrExcel.com · 2009 · Education
Microsoft Excel Tutorial: There is a secret icon that will let you select all of the items on the drawing toolbar. Episode 363 shows you how. Welcome back to the MrExcel netcast, where we provide you with helpful tips and tricks to make your Excel experience smoother. In today's episode, we will be discussing a common problem that many of us face when copying data from a website into Excel - the pesky little graphic icons that come along with it. These icons may be links to check-images or other website features, but they can be a real hassle to delete one by one. But fear not, because I have a hidden trick that will save you time and frustration. First, you need to make sure that the Drawing toolbar is displayed. You can do this by going to View, Toolbars, and selecting Drawing. The toolbar will generally appear at the bottom of your screen, but you can move it to the top for easier access. On the left-hand side of the toolbar, you will see a white arrow - this is the Select Objects arrow. When you click on it, you will enter Select Objects mode, where you won't be able to select cells, but you can drag a rectangle to select multiple objects at once. Once you have selected all the unwanted graphics, simply hit the Delete key and they will disappear. Remember to click on the arrow again to exit Select Objects mode and go back to selecting single cells. This trick will save you a lot of time and effort, especially when dealing with a large number of graphics on a worksheet. So next time you encounter this issue, remember to use the Select Objects arrow and make your life easier. Thank you for tuning in to today's netcast from MrExcel. We hope this tip will come in handy for your future Excel projects. Don't forget to subscribe to our channel for more helpful videos like this one. See you tomorrow for another episode of the MrExcel netcast! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Introduction (00:17) Annoying problem with copying data from website (00:27) Hidden trick for getting rid of graphics (00:39) First step: Display Drawing toolbar (00:50) Using the Select Objects arrow (01:06) Deleting selected objects (01:16) Exiting Select mode (01:26) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelshapes This video answers these common search terms: how to select multiple objects at once in excel how to select multiple images excel choose multiple pictures or icons in excel excel select all graphic objects excel select all embedded images and icons where is select objects in excel select all pictures and icons in excel bulk select images in excel select all shapes and images in excel worksheet bulk selection of images and icons in excel mass select graphics in excel select all objects in excel including images excel select all clip art and pictures Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152732/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920