How to remove sorting in Excel after saving

In Microsoft Office Excel, you can sort the contents of tables by a certain attribute using the tools built into the program. This article will describe the features of canceling sorting before and after saving the document.

How to sort a table in Excel

To bring the table array to the form desired for the user, and not rearrange the data in the columns manually, you must do the following manipulations:

1. Select the whole table or part of it: a column, a row, a certain range of cells. To select elements of the plate, hold down the left key of the manipulator and drag it in the specified direction.

2. Click on the word “Home” in the top toolbar of Microsoft Office Excel and carefully study the interface of the options panel that opens.
3. At the end of the list, find the “Sort and Filter” tab and click on it with LMB. The tab will open as a small menu.

4. Select one of the presented options for sorting data in the table. Here you can sort in alphabetical order or in reverse order.

5. Check result. After specifying one of the options, the table or its selected part will change, the data will be sorted according to a specific attribute specified by the user.

Pay attention! You can also select Custom Sort. In this case, the user will be able to sort the parameters of the table array in ascending order, by date, by font, by several columns, lines, or make dynamic sorting.

How to cancel sorting while working with a document

If the user, while working in an Excel document, accidentally sorted the table data, then to undo his action, he will need to take the following steps:

1. Close the sort window.
2. Deselect all table cells. For this purpose, you need to click the left mouse button on the free space of the worksheet outside the plate.
3. Click on the “Cancel” symbol, which looks like an arrow to the left and is located next to the “File” button in the upper left corner of the screen.

4. Make sure the actions in the document go back one step. Those. the range of cells should be unsorted. The undo function allows you to delete the action that was performed last.
5. You can also undo the last operation in Microsoft Office Excel using a combination of buttons on the computer keyboard. For this purpose, the user needs to switch to the English layout and simultaneously hold down the “Ctrl + Z” keys.

Additional Information! The undo function using the “Ctrl + Z” combination works in all Microsoft Office editors, regardless of their version.

How to cancel sorting after saving excel document

When an Excel work is saved and the user closes the document, all clipboard data is automatically deleted. This means that the “Cancel” button will not work the next time you run the file, and you will not be able to remove the sorting of the table in this way. In this situation, experienced specialists recommend taking a number of simple steps according to the algorithm:

1. Run the Excel file, make sure that the previous work is saved and displayed on the worksheet.
2. Click the right mouse button on the name of the very first column in the plate.
3. In the context window, click on the line “Insert”. After such an action, an auxiliary column will be created in the table.
4. In each row of the auxiliary column, you need to specify a serial number for subsequent columns. For example, from 1 to 5, depending on the number of cells.

5. Now we need to sort the data in the table array in any convenient way. How to do this was described above.
6. Save the document and close it.

7. Run the Microsoft Office Excel file again and sort the auxiliary column in ascending order by selecting it completely and selecting the appropriate option from the list on the Sort and Filter tab.
8. As a result, the entire table should be sorted as an auxiliary column, i.e. take the original form.
9. Now you can delete the first column to avoid confusion and save the document.

Important! You can number an auxiliary column automatically by writing the value only in its first cell and extending it to the end of the table array.

You can also sort the data in the Excel table manually by doing certain calculations, changing the values ​​in the columns and rows between them. However, this process takes a lot of time for the user. It is easier to use a tool built into the software designed to complete the task. In addition, the desired parameters can be sorted by color and cell size.

Conclusion

Thus, sorting in Microsoft Office Excel is done in the shortest possible time with simple methods. To cancel this action after saving the document, you will need to create an additional auxiliary column in the table array, number it, and then sort it in ascending order. The detailed algorithm has been presented above.