Resort Excel sheets, change the order

%3CLINGO-SUB%20id%3D%22lingo-sub-2413525%22%20slang%3D%22en-US%22%3EResort%20Excel%20sheets%2C%20change%20the%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2413525%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20needing%20to%20change%20the%20order%20of%20my%20excel%20sheets%2C%20cannot%20find%20a%20tool%20in%20my%20MS%20365.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2413525%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I'm needing to change the order of my excel sheets, cannot find a tool in my MS 365.

5 Replies

@MSpey  you can click and drag or right-click and select "Move or Copy ..." (desktop version) or "Reorder" in the browser version.

mtarler_0-1622745837573.png

 

@mtarler 

Thank you, very helpful for single sheets. But I want to sort the entire set of sheets either alphabetically or numerically.  I may have to resort to a macro to do this, as I've seen some posted on the web.

yes, sounds like you are looking for / in the need of a macro. The macro you need may be very simple. You likely found an example on you search but if not, start a new topic here specifically requesting help on a macro to sort sheets and I'm sure one of us can help

@mtarler 

Thanks for the reply,  I would of course welcome seeing any sorting macro for the entire workbook of sheets.  I have about 25 sheets and will be generating more.  I have a program that outputs tables to each sheet.  Each sheet is named alphabetically, like an index.

I was going to write something quick but did a search first and found plenty that already have examples and much better instructions/documentation than I would have done. Here are just a few:
from MS:
https://docs.microsoft.com/en-us/office/vba/excel/concepts/workbooks-and-worksheets/sort-worksheets-...
good description and instructions:
https://trumpexcel.com/sort-worksheets/
simply the macro:
https://www.automateexcel.com/vba/sort-sheets-alphabetically/