Resort Excel sheets, change the order

Question

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

mtarler · Answer

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

mspey · Answer

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

mtarler · Answer

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

mspey · Answer

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

mtarler · Answer

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-alphanumerically-by-namegood description and instructions:https://trumpexcel.com/sort-worksheets/simply the macro:https://www.automateexcel.com/vba/sort-sheets-alphabetically/

Forum Discussion

Resort Excel sheets, change the order

5 Replies

Resources