Excel How to Auto-Alphabetize a Specific Range in Excel?

Aug 9, 2016
Reaction score
I'm trying to find a macro which will automatically sort alphabetically by a specific range.

After I filter column A (for a specific reoccurring value) I want the remaining values in columns AC-AH to sort alphabetically by column AD automatically.

I've looked all over the internet but cant seem to find one applicable. I know how to run them but no idea how to create on myself!

Any suggestions?


Mar 25, 2003
Reaction score
Welcome to the forum! :)

If you're new to macros then the easiest way to create one is to record it manually. Go to the View tab and click on the downward pointing arrow below the Macro button, then select Record macro. You will have to give it a name, and you can assign a shortcut to it. Once you have entered the information click on OK and go through the actions you want to record. When you are finished click on the downward pointing arrow again and select Stop recording.

If I've missed the point of what you're asking let me know!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question