ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I sort rows by the contents of one cell (https://www.excelbanter.com/excel-discussion-misc-queries/225881-how-do-i-sort-rows-contents-one-cell.html)

bhaight58

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

dlw

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