How to Organize Excel Sheets into Folders (2 Effective Ways)

When you have too many Excel files in a folder, it becomes very difficult to find a specific workbook among the mess. So, organizing Excel sheets in a particular manner is really necessary. One of two ways of organizing Excel sheets into folders is sorting and grouping. In this article, I will show you how to organize Excel sheets into folders using sorting and grouping. So, without having any further discussion, let’s get started.


2 Ways to Organize Excel Sheets into Folders

I have 5 Excel sheets saved in a folder called “New Folder”. I will use these Excel sheets to show you how to organize Excel sheets into folders.

Here I’m using Windows 10 Operating System. But this tutorial is valid for any version of Microsoft OS.

Organize Excel Sheets into Folders


1. Organize Excel Sheets into Folders by Sorting

The Sort command can organize Excel sheets alphabetically. When you have a ton of Excel files saved within the same folder, sorting really helps to organize them well.

There are two ways of sorting Excel files into a folder. The first one is Ascending Order and the second one is Descending Order. By default, all the Excel files are sorted in ascending order.

Now I’m going to discuss how to sort Excel sheets both in ascending and descending order one by one.


1.1. Sort in Ascending Order

Sorting Excel files in ascending order means the Excel files will be sorted from A to Z based on the file names. To sort Excel files in ascending order follow the step below:

❶ First navigate to the folder where you have kept all the Excel files.

❷ Then go to the View tab.

❸ After that click on the Sort by drop-down menu.

There you will see that the Name option is already selected.

❹ Just click on the Ascending command to sort in ascending order.

After that, you will see that the Excel files are sorted in ascending order based on the file names.

Organize Excel Sheets into Folders by Sorting

You can also change the Sort by option from Name to any other options. Such as,

  • Date Modified
  • Type
  • Size
  • Date created
  • Authors
  • Categories
  • Tags
  • Title


1.2. Sort in Descending Order

Sorting Excel files in descending order will organize all the Excel file names from Z to A.

To sort Excel sheets in descending order,

❶ Go to the View tab first.

❷ Then click on the Sort by drop-down menu.

You will see that by default the Sort by option is selected as Name. You can change it to any other options though.

❸ Now, click on the Descending command.

After that, you will see that the Excel sheets are organized in descending order based on the file names.

Organize Excel Sheets into Folders by Sorting

Read More: How to Group Tabs Under a Master Tab in Excel (with Quick Steps)


2. Organize Excel Sheets by Grouping

Grouping is another way to organize Excel sheets into folders. After applying the Group by command, your Excel files will be divided into several groups based on the different parameters such as Name, Date, Type, etc.

To group Excel sheets,

❶ Go to the View tab first.

❷ Then click on the Group by drop-down menu.

❸ After that, select Name.

This will group Excel files based on their file names.

Organize Excel Sheets into Folders by Grouping

However, you can group your Excel files based on other parameters too. Here, I’m showing you to group by files based on “Date modified”.

  • Go to the View
  • Click on the Group by drop-down menu.
  • Select Date modified.

Now you will notice that the Excel files have been grouped based on their date of modification.

Organize Excel Sheets into Folders by Grouping

Let’s say you want to ungroup your Excel files. Well, that is very simple too. To ungroup your Excel sheets,

  • Again go to the View
  • Click on the Group by drop-down.
  • Select (None) from the drop-down list.

Now check your Excel files. This time you will notice that all the Excel sheets have been ungrouped as before.

Read More: How to Ungroup Worksheets in Excel (5 Easy Ways)


Conclusion

To sum up, we have discussed 2 methods to organize Excel sheets into Folders. Please don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.


Related Articles

Mrinmoy Roy

Mrinmoy Roy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

5 Excel Tips
You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo