how do I sort rows by the contents of one cell

B

bhaight58

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
 
D

dlw

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to sort a column of data which is the SUM of three cols 1
Advanced Sort Question 1
Sort by last two characters, not the first. 4
How to sort entire spreadsheet by one column sort 5
help formatting columns 2
How do I sort in Excel? 1
how to treat rows as one record 1
How do I find a value in a table without using the labels? 1

Top