![]() |
how do I sort rows by the contents of one cell
I have a large worksheet that has multiple coulmns of data, in different
formats. The problem is I need to sort decending based on just one coulmn. however when I try to do that it just moves that single coulmn around. is there any way to "lock" the row together and then let me adjust by the data in that coulmn? thanks |
how do I sort rows by the contents of one cell
yes, select all the rows, click on heading A, hold shift key down and click
on the last column or just click on the blank square up in the corner between A and 1, that selects everything "bhaight58" wrote: I have a large worksheet that has multiple coulmns of data, in different formats. The problem is I need to sort decending based on just one coulmn. however when I try to do that it just moves that single coulmn around. is there any way to "lock" the row together and then let me adjust by the data in that coulmn? thanks |
All times are GMT +1. The time now is 02:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com