ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I sort by complete rows in excell (https://www.excelbanter.com/excel-worksheet-functions/20140-how-do-i-sort-complete-rows-excell.html)

Snoopy

How do I sort by complete rows in excell
 
I need to sort the cells in column A and with the data in each row remaining
attached to the cells sorted.

Debra Dalgleish

If you select a column, and click one of the Sort buttons, Excel may
sort only that column, and the data will be scrambled.

You can select ONE cell in the column, then click the Sort button.

Or, to be safe, select all the cells in the table, then choose
DataSort. There are instructions he

http://www.contextures.com/xlSort01.html

Snoopy wrote:
I need to sort the cells in column A and with the data in each row remaining
attached to the cells sorted.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Snoopy

This should do what I need. Thanks for the help.

"Debra Dalgleish" wrote:

If you select a column, and click one of the Sort buttons, Excel may
sort only that column, and the data will be scrambled.

You can select ONE cell in the column, then click the Sort button.

Or, to be safe, select all the cells in the table, then choose
DataSort. There are instructions he

http://www.contextures.com/xlSort01.html

Snoopy wrote:
I need to sort the cells in column A and with the data in each row remaining
attached to the cells sorted.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com