Horizontal/Column filtering in Excel? Should be simple
up vote
1
down vote
favorite
In Excel it is straight forward to apply a filter on a column (mark the region of interest, klick on data>filter). This way you get the handy option to show the content corresponding to, e.g., a value by a "simple click".
For example, say a I have the weekdays repeating over and over in one column and various data in the other columns. By the filtering described above, I can, with a click, show rows corresponding to, say, mondays only.
If we call the filtering described above vertical, how do I accomplish horizontal filtering in the same simplistic manner?
It should be very simple, but I cannot find any way to do this. Annoying!
microsoft-excel microsoft-excel-2010
add a comment |
up vote
1
down vote
favorite
In Excel it is straight forward to apply a filter on a column (mark the region of interest, klick on data>filter). This way you get the handy option to show the content corresponding to, e.g., a value by a "simple click".
For example, say a I have the weekdays repeating over and over in one column and various data in the other columns. By the filtering described above, I can, with a click, show rows corresponding to, say, mondays only.
If we call the filtering described above vertical, how do I accomplish horizontal filtering in the same simplistic manner?
It should be very simple, but I cannot find any way to do this. Annoying!
microsoft-excel microsoft-excel-2010
1
Read about excel pivot table
– DavidPostill♦
Oct 22 '14 at 9:36
1
excel.tips.net/T007453_Filtering_Columns.html gives some ideas
– DavidPostill♦
Oct 22 '14 at 9:37
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
In Excel it is straight forward to apply a filter on a column (mark the region of interest, klick on data>filter). This way you get the handy option to show the content corresponding to, e.g., a value by a "simple click".
For example, say a I have the weekdays repeating over and over in one column and various data in the other columns. By the filtering described above, I can, with a click, show rows corresponding to, say, mondays only.
If we call the filtering described above vertical, how do I accomplish horizontal filtering in the same simplistic manner?
It should be very simple, but I cannot find any way to do this. Annoying!
microsoft-excel microsoft-excel-2010
In Excel it is straight forward to apply a filter on a column (mark the region of interest, klick on data>filter). This way you get the handy option to show the content corresponding to, e.g., a value by a "simple click".
For example, say a I have the weekdays repeating over and over in one column and various data in the other columns. By the filtering described above, I can, with a click, show rows corresponding to, say, mondays only.
If we call the filtering described above vertical, how do I accomplish horizontal filtering in the same simplistic manner?
It should be very simple, but I cannot find any way to do this. Annoying!
microsoft-excel microsoft-excel-2010
microsoft-excel microsoft-excel-2010
edited Oct 22 '14 at 9:34
DavidPostill♦
102k25216252
102k25216252
asked Oct 22 '14 at 8:52
tjoflong
613
613
1
Read about excel pivot table
– DavidPostill♦
Oct 22 '14 at 9:36
1
excel.tips.net/T007453_Filtering_Columns.html gives some ideas
– DavidPostill♦
Oct 22 '14 at 9:37
add a comment |
1
Read about excel pivot table
– DavidPostill♦
Oct 22 '14 at 9:36
1
excel.tips.net/T007453_Filtering_Columns.html gives some ideas
– DavidPostill♦
Oct 22 '14 at 9:37
1
1
Read about excel pivot table
– DavidPostill♦
Oct 22 '14 at 9:36
Read about excel pivot table
– DavidPostill♦
Oct 22 '14 at 9:36
1
1
excel.tips.net/T007453_Filtering_Columns.html gives some ideas
– DavidPostill♦
Oct 22 '14 at 9:37
excel.tips.net/T007453_Filtering_Columns.html gives some ideas
– DavidPostill♦
Oct 22 '14 at 9:37
add a comment |
2 Answers
2
active
oldest
votes
up vote
0
down vote
I have uploaded a video showing exactly how to accomplish horizontal filtering.
https://www.youtube.com/watch?v=icpLC3CqMUs
Hope this helps.
Regards
Irfan
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
– Donald Duck
Aug 14 '17 at 15:22
add a comment |
up vote
0
down vote
Another way would be to use Transpose function in an array form. Steps as follows:
1. Select your destination area first.
2. In the formula box type following: "=Transpose(source)"
3. Instead of hitting enter, you must hit ctrl+shift+enter.
What step 3 does is create an array type that links to your source data. This is similar to copy/paste link except it transposes the data, at which point you just filter as usual.
If done properly your code may look like this:
{=TRANSPOSE(A1:Z100)}
In every single destination cell.
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
I have uploaded a video showing exactly how to accomplish horizontal filtering.
https://www.youtube.com/watch?v=icpLC3CqMUs
Hope this helps.
Regards
Irfan
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
– Donald Duck
Aug 14 '17 at 15:22
add a comment |
up vote
0
down vote
I have uploaded a video showing exactly how to accomplish horizontal filtering.
https://www.youtube.com/watch?v=icpLC3CqMUs
Hope this helps.
Regards
Irfan
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
– Donald Duck
Aug 14 '17 at 15:22
add a comment |
up vote
0
down vote
up vote
0
down vote
I have uploaded a video showing exactly how to accomplish horizontal filtering.
https://www.youtube.com/watch?v=icpLC3CqMUs
Hope this helps.
Regards
Irfan
I have uploaded a video showing exactly how to accomplish horizontal filtering.
https://www.youtube.com/watch?v=icpLC3CqMUs
Hope this helps.
Regards
Irfan
answered Aug 14 '17 at 14:34
Irfan Afzal
1
1
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
– Donald Duck
Aug 14 '17 at 15:22
add a comment |
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
– Donald Duck
Aug 14 '17 at 15:22
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
– Donald Duck
Aug 14 '17 at 15:22
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
– Donald Duck
Aug 14 '17 at 15:22
add a comment |
up vote
0
down vote
Another way would be to use Transpose function in an array form. Steps as follows:
1. Select your destination area first.
2. In the formula box type following: "=Transpose(source)"
3. Instead of hitting enter, you must hit ctrl+shift+enter.
What step 3 does is create an array type that links to your source data. This is similar to copy/paste link except it transposes the data, at which point you just filter as usual.
If done properly your code may look like this:
{=TRANSPOSE(A1:Z100)}
In every single destination cell.
add a comment |
up vote
0
down vote
Another way would be to use Transpose function in an array form. Steps as follows:
1. Select your destination area first.
2. In the formula box type following: "=Transpose(source)"
3. Instead of hitting enter, you must hit ctrl+shift+enter.
What step 3 does is create an array type that links to your source data. This is similar to copy/paste link except it transposes the data, at which point you just filter as usual.
If done properly your code may look like this:
{=TRANSPOSE(A1:Z100)}
In every single destination cell.
add a comment |
up vote
0
down vote
up vote
0
down vote
Another way would be to use Transpose function in an array form. Steps as follows:
1. Select your destination area first.
2. In the formula box type following: "=Transpose(source)"
3. Instead of hitting enter, you must hit ctrl+shift+enter.
What step 3 does is create an array type that links to your source data. This is similar to copy/paste link except it transposes the data, at which point you just filter as usual.
If done properly your code may look like this:
{=TRANSPOSE(A1:Z100)}
In every single destination cell.
Another way would be to use Transpose function in an array form. Steps as follows:
1. Select your destination area first.
2. In the formula box type following: "=Transpose(source)"
3. Instead of hitting enter, you must hit ctrl+shift+enter.
What step 3 does is create an array type that links to your source data. This is similar to copy/paste link except it transposes the data, at which point you just filter as usual.
If done properly your code may look like this:
{=TRANSPOSE(A1:Z100)}
In every single destination cell.
answered Sep 16 at 6:39
ReturnVoid
116114
116114
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f829934%2fhorizontal-column-filtering-in-excel-should-be-simple%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Read about excel pivot table
– DavidPostill♦
Oct 22 '14 at 9:36
1
excel.tips.net/T007453_Filtering_Columns.html gives some ideas
– DavidPostill♦
Oct 22 '14 at 9:37