Filter Help

  • Thread starter Thread starter TheRed
  • Start date Start date
T

TheRed

I am creating a spreadsheet that has several columns that are
associated in rows. Because I'm not very good at explaining this,
take the following example (this is a simple example I made up):

Account # First NameLast Name Date Opened
15647 John Simpson 2/2/2002
25688 Mary Marts 5/4/1999
24641 Susan Fronger 6/30/2000
15632 Albert Plate 12/8/2001

John Simpson's Account # is 15647 and he opened his account on
2/2/2002. Mary Marts Account # is 25688 and she opened her account on
5/4/1999, etc., etc.. If I place a filter on the Account #, then Sort
Ascending, the Account #s don't stay "associated" with the other items
in their respective rows, only the Account #s sort. For example, if I
Sort Ascending the above example, I get:

Account # First NameLast Name Date Opened
15632 John Simpson 2/2/2002
15647 Mary Marts 5/4/1999
24641 Susan Fronger 6/30/2000
25688 Albert Plate 12/8/2001

How can I keep the rows together??

Thank you in advance for your help!
 
Make sure the filter is applied in all columns that you want to include, I
have no problems sorting and keeping the rows together
 
TheRed said:
I am creating a spreadsheet that has several columns that are
associated in rows. Because I'm not very good at explaining this,
take the following example (this is a simple example I made up):

Account # First NameLast Name Date Opened
15647 John Simpson 2/2/2002
25688 Mary Marts 5/4/1999
24641 Susan Fronger 6/30/2000
15632 Albert Plate 12/8/2001

John Simpson's Account # is 15647 and he opened his account on
2/2/2002. Mary Marts Account # is 25688 and she opened her account on
5/4/1999, etc., etc.. If I place a filter on the Account #, then Sort
Ascending, the Account #s don't stay "associated" with the other items
in their respective rows, only the Account #s sort. For example, if I
Sort Ascending the above example, I get:

Account # First NameLast Name Date Opened
15632 John Simpson 2/2/2002
15647 Mary Marts 5/4/1999
24641 Susan Fronger 6/30/2000
25688 Albert Plate 12/8/2001

How can I keep the rows together??

Thank you in advance for your help!
Click to expand...

First of all, make sure that you've highlighted _all_ the rows and columns,
not just the Account # column. (Use Control+A or click that box to the left
of Column A and above Row 1)

If you only want to do your sort by Column A (Account #), then just use the
sort command on your toolbar --- it will default to sorting by Column A.

If you'd like to sort by columns other than A, at the top of your toolbar
select "Data", then select "Sort" from the dropdown menu, and you'll get a
dialog box which will let you choose which column you want to sort by.

In either case, the key is to have first selected all the columns and rows
you wish to keep together.
 
While it is correct that shopuld select all data that you want to sort f you
are using auto filter it is not necessary to select all data as long
as the filter is applied on all columns with data. I suspect the OP didn't
have that
 
Peo Sjoblom said:
While it is correct that shopuld select all data that you want to sort f
you are using auto filter it is not necessary to select all data as long
as the filter is applied on all columns with data. I suspect the OP didn't
have that --
Regards,

Peo Sjoblom
Click to expand...


I'm sure I'm betraying my ignorance of excel by asking this question, but
how does one make sure that, as you say, "the filter is applied on all
columns with data"? Wouldn't one have to select all the data?

--
Alan

A: Because it runs counter to the normal flow of communication.
Q: Why is top-posting frowned upon?

-------------------------------------------------------------------------------------------------------
 
If you have A:H with auto filter applied then there would be an autofilter
dropdown in all those columns so you only have to look for the headers
As long as you have a dropdown those columns would be included in your
Since they weren't for the OP I assume he didn't have the filter applied to
all
columns that he wanted to sort. It all depends on how well you know your
data, I am not saying your method is wrong, in fact it is a good method and
probably the best way to go but as long as you have filters in all headers
and the data is contiguous or was when the filter was applied the first time
it is not necessary to select all data like you would if you were only
sorting a table without filters
 
Back
Top