“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.
Created with content provided by Katie Caplan, Client Service Coordinator, and Margo Almond, Instructor.
Director of Communications,
Sector Learning Solutions