I need help with sort by a certian column in excel. Everytime i do it my way it messes up my other data. How do i sort by one column with keeping all the other information in the correct order? HELP
2007-03-22 03:16:11 · 5 answers · asked by Sheilamarie 2 in Computers & Internet ➔ Software
Be sure to highlight all the columns and all the data, then sort on the desired col. Alll data will be carried correctly with the rows.
2007-03-22 03:20:35 · answer #1 · answered by ed 7 · 0⤊ 0⤋
Cut the columns that you want to keep them , then sort the other(s) , and past the columns again .
2007-03-22 03:25:09 · answer #2 · answered by Jan Kusa 1 · 0⤊ 0⤋
Type in the data, select it, and then in the data menu, select the sort option. In the first dropdown, select the column you want your data to be sorted by, and then select how it should be sorted... (ascending, descending) That should fix your issue!!!
2007-03-22 03:28:14 · answer #3 · answered by Divs M 2 · 0⤊ 0⤋
sort and chose the expand the selection option
2007-03-22 03:22:02 · answer #4 · answered by Mark F 2 · 0⤊ 0⤋
interior the variety demonstrate screen there is an determination on the backside for Header row or no header row. make certain header row is chosen and it is going to leave the header row and variety something.
2016-11-27 22:02:16 · answer #5 · answered by ? 4 · 0⤊ 0⤋