Sort Sheets by alphanumeric or date In Excel
Sort your sheets in your current workbook ascending or descending by alphanumeric or date sorting, this is useful when you have a huge number of sheets and want to view them as sorted or when you have sheets names as date and want the sheets sorted by day, month, year. Dose for Excel’s Sort utility can quickly do the task with one click.
Click DOSE » Sort
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-sort-sheets.png)
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-sort-sheets-pane.png)
Sort Excel sheets by alphanumeric
- Click on DOSE » Sort and a sort worksheets pane will open.
- Check Alpha Numeric Sorting option to sort sheets by alphanumeric (Characters and Numbers), and check Ascending option if you want to sort sheets in ascending order (A to Z) or check Descending option if you want to sort sheets in descending order (Z to A).
- And then click Apply. In below example, Sheets are sorted by alphanumeric in an ascending order. See screenshots.
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-sort-sheets-alpha-test.png)
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-sort-sheets-alpha-result.png)
Sort Excel sheets by date
- Click on DOSE » Sort and a sort worksheets pane will open.
- Check Date Sorting option to sort sheets by Date, and check Ascending option if you want to sort sheets in ascending order (Oldest to Newest) or check Descending option if you want to sort sheets in descending order (Newest to Oldest).
- And then click Apply. In below example, Sheets are sorted by date in an ascending order. See screenshots.
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-sort-sheets-date-test.png)
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-sort-sheets-date-result.png)
Sort Excel sheets based on custom lists
- Click on DOSE » Sort and a sort worksheets pane will open.
- Check Based on Custom List option to sort sheets by the custom list values.
- And then click Apply. In below example, Sheets are sorted by month name in an according to the custom list order. See screenshots.
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2023/07/sort_worksheets_custom_list_pane.png)
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651.png)
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2023/07/sort_worksheets_custom_list_test_old.png)
![Excel Sort Sheets](https://zbrainsoft.com/wp-content/uploads/2023/07/sort_worksheets_custom_list_test_new.png)
More Features:
Excel Select Merged Cells
Quickly Select Merged Cells It seems a little difficult to select only merged cells in…
Excel Insert Empty
Insert Empty Rows Or Columns At Certain Interval In Excel If you ever want to…
Excel Compare Sheets
Compare Sheets In Excel Comparing Excel sheets will take long time if doing it manually,…
Excel Delete Columns
Highlight Or Delete Any Type Of Columns Highlight or delete identical, empty, or hidden cell…
Excel Split
In Excel, split the first and last word, or divide them by a delimiter or…
Excel Extend Selection To The Last Used Column
Easily Extend Selection To The Last Used Column Normally if you want to select a…