Lock Rows In Excel Mac For Sorting

Instead of sorting a single column (as dellipandy suggests) you need to use the entire table to sort, keeping the row values together. One test is worth a thousand opinions. Click the * below to say thanks.

In Excel, you can use the Sort function to sort a column and keep rows. Select the column data you want to sort, and then click Data > Sort. See screenshot: 2. In the Sort Warning dialog, keep Expand the selection option checked, and click Sort.

In the Sort dialog, specify the criterion that you will sort on and the sorting order. See screenshot: 4. Now the selected column has been sorted and the intact rows are still kept. If you want to sort the column data based on the absolute values, the Sort function of Excel cannot directly help you sort them. Now I introduce the Advanced Sort of Kutools for Excel for you. Sort a column but keep rows by Advanced Sort function With Kutools for Excel’s Advanced Sort function, you can sort data by absolute value, month, day, frequency, last name and so on. With more than 300 handy Excel add-ins, free to try with no limitation in 60 days.

After Kutools for Excel, please do as below: 1. Select all the data range and then click Enterprise > Advanced Sort. See screenshot: 2. In the Advanced Sort dialog, select the column you want to sort, and then select the criterion you want to sort on, then select the sorting order.

See screenshot: 3. Now the selected column data has been sorted with intact rows kept. If you are interested in Kutools for Excel’s Advanced Sort utility, you can Advanced Sort. Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful: • Merge Cell/Rows/Columns without Losing Data.

• Combine and Consolidate Multiple Sheets and Workbooks. • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter, • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.