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. |
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 |
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