ok i have column A as a manger name, Column B with Customer, and whenever i filter Column B to go in ascending order so they are alphabetically lined up. and for some reason i cant get column A to line up as well. can anyone help me?
2007-02-27 08:54:03 · 6 answers · asked by kp 3 in Computers & Internet ➔ Software
Highlight both columns and select auto filter - this should solve the problem.
if this is not the case then re make the filter.
It may also be a case that you do not have enough data in the columns.
2007-02-27 08:57:11 · answer #1 · answered by Chεεrs [uk] 7 · 0⤊ 0⤋
I don't know what you mean by "line up as well" but if Column A is staying put while you sort column B, then all you have to do is highlight all the cells (in both columns) you want sorted and then sort them by Column b ascending.
2007-02-27 09:00:51 · answer #2 · answered by boonestudent18 3 · 0⤊ 0⤋
It sounds to me like you don't really need a filter, you are actually SORTING. Select your whole sheet, then select "Data" , "Sort" in the menus. If you have column headings, you can choose which one to sort by, otherwise, choose the column by name (ie: column A, Column B etc)
2007-02-27 09:00:43 · answer #3 · answered by friend4keith 2 · 0⤊ 0⤋
if you mark column B and sort it, it will only sort column B. Do NOT mark the column, goto the menu data -> sort and chose column B there. Then it should align the columns and sort by column B
good luck
M.
2007-02-27 08:58:20 · answer #4 · answered by Martin G. 4 · 0⤊ 0⤋
might be spaces in column A screwing it up
2007-02-27 08:57:30 · answer #5 · answered by Anonymous · 0⤊ 0⤋
you have to do a dual sort. it is in the same sort operation but you have to fill in the "and then by" so, fill out the first sort field as "b"-And then by --"a" that will keep the customer records sorted for each manager.
2007-02-27 09:00:59 · answer #6 · answered by R 2 · 0⤊ 0⤋