Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Well, I know nothing about assigning Macros (and I'm hoping not to anytime soon) so I'm hoping to do this as painless as possible.

I want it that, for example a picture, when I click it, it will automatically Sort & Filter all of Column 'C'.

I am being rather specific, so I do understand if this can't be done. Thanks for anyones' help. :)

share|improve this question
up vote 2 down vote accepted

It can be done. It's just a matter of how much you are prepared to stretch and learn.

A starting point would be to record a macro: Open your workbook, click the icon to record a macro.

enter image description here

Click through the steps to sort and filter your data. Then click to stop the macro recorder.

enter image description here

You can now insert a shape on the sheet, right-click the shape and assign the macro to the shape.

enter image description here

You can also assign a macro to a picture, instead of a shape, and the macro will run when the picture is clicked.

If you need more details about what the macro should actually do, please start a new question and post the requirements for the actual macro.

share|improve this answer
Oh My Goodness, you have saved my Excel life forever. I never knew Macros were so easy! Thank you SO much! – Mordecaii Apr 19 '13 at 10:20

Your Answer


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.