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.
How to Organize Excel Sheets into Folders: 2 Effective Ways
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.
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.
You can also change the Sort by option from Name to any other options. Such as,
- Date Modified
- Date created
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.
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.
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 tab.
- 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.
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 tab.
- 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.
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.