G Guest Apr 1, 2005 #1 I need to sort the cells in column A and with the data in each row remaining attached to the cells sorted.
I need to sort the cells in column A and with the data in each row remaining attached to the cells sorted.
D Debra Dalgleish Apr 1, 2005 #2 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 Data>Sort. There are instructions here: http://www.contextures.com/xlSort01.html
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 Data>Sort. There are instructions here: http://www.contextures.com/xlSort01.html