Reordering ordinal numbers in Excel is a common requirement, especially when the data has been edited or moved multiple times, and the original ordinal numbers can become out of order. In this case, it is important to reorder the ordinal numbers in order to better organize and understand the data. The following will show you how to reorder the ordinal numbers in Excel in detail.
First, open your Excel**. Suppose your ordinal column is in column A, then you need to select all cells in column A that contain ordinal numbers. You can select the entire column by clicking on the header of column a, or select a specific range of cells by dragging the mouse.
Once the cells are selected, the next thing to do is to sort them. In the top menu bar of Excel, find and tap the "Start" tab. Under the Home tab, there is an Edit group that contains a variety of editing tools, including Sort and Filter. Click on the small arrow under "Sort & Filter" and a drop-down menu will pop up.
In the drop-down menu, there are a variety of sorting options to choose from, such as "ascending", "descending", and "custom sorting", among others. Since we need to reorder the sequence numbers, we select "Custom Sorting" here. After clicking "Custom Sorting", Excel will pop up a "Sorting" dialog box.
In the Sort dialog box, there are a few key settings to be aware of. The first is the "Expand Selected Area" option, which applies sorting to other related cells in addition to the selected cell to maintain the integrity of the data. Make sure this option is checked.
The next step is to set the keywords and order of sorting. In the Main Keywords drop-down list, select Ordinal number to indicate that we want to sort by ordinal number. In the Sort by drop-down list, select Cell Value, which means we want to sort the cells based on their actual values, not based on other criteria, such as font color or cell color.
Finally, in the Order drop-down list, select Ascending to indicate that we want to sort the sequence numbers from smallest to largest. If you want to sort from largest to smallest, you can select "Descending".
Once you have set these options, click the "OK" button and Excel will reorder the serial numbers according to your settings. After the sorting is completed, you will find that the ordinal numbers of column A have become neat and orderly, and the data of other columns has been adjusted accordingly according to the ordinal numbers, maintaining the correspondence with the ordinal columns.
In addition to the above methods, Excel also provides some other sorting functions and options, such as multi-column sorting, sorting by rows, etc., which can be selected and applied according to specific needs. Mastering these sorting techniques can greatly improve the efficiency and accuracy of your data processing in Excel.
In conclusion, reordering ordinal numbers in Excel is a simple but practical operation that can be achieved in a few simple steps. Whether at work or in daily life, mastering this skill will bring you great convenience. Hopefully, the above content can help you better apply Excel and improve your work efficiency.