A simple trick to go to a specific picture quickly

Here’s the situation: You have many pictures on a spreadsheet, how can you go to a specific picture quickly?Excel Tips - Go to object

Selection and Visibility Pane is on the top of my mind…… but as you see from the above screenshot, you won’t succeed without the magic.

Before I show you the trick, let’s start with something basic.

When we insert an object, for example a picture, Excel gives a name to it as Picture 1, Picture 2, Picture 3 and so on…Excel Tips - Go to object 1

As a good practice, we should assign a meaningful name to the picture rather than just Picture 1, Picture 2…

This can be easily done by inputting the name directly in the Name Box, or on the Selection and Visibility Pane, while the object is selected.

Note: To open the Selection and Visibility Pane, go to Home, Editing Group, Find & Select, Selection Pane…

Excel Tips - Go to object 2

Or simply use the shortcut Alt+F10

Now, I have inserted 10 pictures from Clip Art and named them accordingly.Excel Tips - Go to object 3.PNG

I click on “Bear” on the Selection and Visibility Pane, the picture “Bear” on the worksheet is selected.

However, when I click on “Koala”, the picture “Koala” is selected but not displayed because “Koala” is not on the active view.  I have to scroll down to locate the “Koala” all by myself.  Quite disappointing!  Excel Tips - Go to object 4

It may not be a big issue if I have only a few pictures sitting next to each other on my spreadsheet… But it could be a real frustration if we are dealing with a lot of pictures spreading all over the spreadsheet.

Show me the object (picture) I have selected, PLEASE!Excel Tips - Go to object 5.PNG

Here’s the trick:

  1. Click on the Object (in our example: Koala) on the Selection and Visibility Pane 
  2. Press Down Arrow once (any arrow would do)
  3. Press Ctrl+Z

There you go.

Note: I am using Excel 2010.  Not sure if that has been improved in Excel 2013 or 2016.  Please let me know if that’s the case.

This entry was posted in Excel Tips and tagged . Bookmark the permalink.

5 Responses to A simple trick to go to a specific picture quickly

  1. diondan1 says:


    I am using the Tab key, no Ctrl+Z needed. Also after renaming the images you can select an image by typing its name in the Name Box + Tab and voilà.



    • MF says:

      Hi Daniel,
      Thanks for your tip. I tried that but pressing Tab takes me to the ‘previous’ object instead. I still need to press Shift+Tab to go to the one I want.


  2. Michael Avidan says:

    Nice old trick.
    I, usually, prefer to press the Space-Bar because pressing an Arrow key (longer than needed) will shift the Shape from its place – something we like to avoid.


Comments, suggestions, corrections are welcome.

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