Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I know I can always click on them one at a time, but that is very time consuming. I can rope select many cells at a time, but if there are pictures in the spreadsheet, it will ignore the pictures. Is there any way to change the selection mode in Excel so that picture can be selected via the rope method?

share|improve this question

3 Answers 3

up vote 7 down vote accepted

On the Home Tab, go to Find and Select, Select Objects, your cross pointer becomes an arrow and you can now rope select.

Repeat the steps to get back to your normal pointer (it will get majorly confusing for most users since you cannot select cells anymore).

share|improve this answer
    
+1 because I learned a new thing today. :) The select objects option in Word is in a similar spot, but it has its own visible button there. I was totally missing it within the "binoculars" button in Excel. –  techturtle Nov 2 '12 at 19:52

Don't know about a rope method but this works

  • Select worksheet
  • Hit Alt+F11
  • Hit Ctrl+G
  • Type this and hit Enter:

    Activesheet.pictures.Select
    
  • If you just want to select one, replace the above line with

    Activecell.pictures.Select
    

Or you could add Select Multiple Objects to your Drawing Toolbar (click the little arrow at the end of the toolbar and use Add/Remove button).

share|improve this answer
1  
+1 for using the immediate window, I like that. –  nutsch Nov 2 '12 at 16:03
    
That immediate window trick may have just changed how I use Excel forever. –  Joel B Nov 2 '12 at 18:20
    
I usually use it to offset complicated selections rather than reselect –  nutsch Nov 2 '12 at 19:05

I'm not aware of a way to "rope select" in Excel, but there is a tool in Excel for selecting multiple images quickly. Start by selecting one image so you gain access to the Picture Tools section of the task ribbon. On the Format tab, in the Arrange section, click on Selection Pane. This will open a Selection and Visibility pane, typically on the right of the window, with all the images from your workbook shown in a list. From here you can use Ctrl+Click to select multiple images quickly, or press Ctrl+A to select them all at once.

P.S. PowerPoint has the same tool.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.