Excel 2010 – Sorting Multiple Worksheets Alphabetically

“In Excel 2010, is there a way to sort multiple worksheets all at once within one workbook without running a macro?”

Issue: An Excel spreadsheet with 25 Excel worksheets that needed to be sorted alphabetically. The client was using a macro, but thought there ought to be an easier way.

Solution:  According to Sector instructor, Margo Almond, “running a macro is the simplest, safest way to sort multiple worksheets alphabetically.” Alternative workarounds do exist, but are more complicated and run the risk of messing up your data.

What is a Macro?
Macros record a sequence of actions (such as mouse clicks and keystrokes) and play those actions back in the exact same order. Macros are created to automate a series of steps requierd to perform a certain task – reducing multiple steps into one – saving you time and the boredom of repetion.

excel-2010-macro

Created with content provided by Katie Caplan, Client Service Coordinator, and Margo Almond, Instructor.

-Kelly Marshall,
Director of Communications,
Sector Learning Solutions

Advertisements

One response to “Excel 2010 – Sorting Multiple Worksheets Alphabetically

  1. Great work! That is the type of information that are meant to be shared across the net. Disgrace on the seek engines for not positioning this submit higher! Come on over and seek advice from my website . Thank you =)

Leave a Reply

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