Forum Discussion

Jdsrated's avatar
Jdsrated
Copper Contributor
Jun 30, 2023

Auto Sorting ALL rows by the data from single column

I am building a "Standings Sheet" for a Bowling League that sorts all the players in a placing by their game average so I don't have to manually move everyone around every week. I need the ENTIRE row with the name of the bowler and all their stats in the cells to be moved up or down by the value in one of those columns. So far, every attempt I have made has failed. I often get the error (all merged cells need to be same size)

 

Thanks in advance. 

excel
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jun 30, 2023

    Jdsrated 

    To automatically sort all rows by the data in a single column in Excel, you can use the following steps:

    1. Select the entire range of data, including the column headers and all the rows you want to sort.
    2. Go to the "Data" tab in the Excel ribbon and click on the "Sort" button.
    3. In the Sort dialog box, choose the column you want to sort by from the "Sort by" dropdown list.
    4. Select the sorting order (e.g., ascending or descending) from the "Order" dropdown list.
    5. Make sure the "Header row" checkbox is checked if your data has headers.
    6. Click on the "Options" button in the Sort dialog box.
    7. In the Options dialog box, check the "Sort left to right" checkbox.
    8. Click on the "OK" button to close the Options dialog box.
    9. Finally, click on the "OK" button in the Sort dialog box to apply the sorting.

    This process will sort the entire rows based on the values in the selected column. The corresponding data in each row will move along with the row during the sorting process.

    Regarding the error message about merged cells, it is important to ensure that there are no merged cells within the range you are sorting. Merged cells can cause issues with sorting. Unmerge any merged cells in the range before performing the sorting operation.

    If you still encounter any issues or need further assistance, please provide more specific details about your data structure and the steps you have tried, and I will be happy to help you further. The texts, steps and functions were created with the help of AI for reasons of time.

    My answers are voluntary and without guarantee!

    I hope this will help you.

Resources