Filter in Excel

1.  How can we set the filter for the alternative columns in Excel.

i.e, we need to set filter for Column A and Column D. The Filter should not be set column B and Column C.

2.   In a single cell how to have two hyperlink?
Murugesh PerumalAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hi schellaa:
1. Filters work on lists, and Excel recognizes only one list per sheet, so filtering two non-adjacent columns at the same time cannot be done.
2. Clicking on a cell hyperlink can follow only one hyperlink at a time, but you could make it change depending on the result of another cell using the HYPERLINK formula for example. Or a macro could be triggered when the cell is clicked using a Worksheet_FollowHyperlink

Perhaps if you could provide more detail on what outcomes you would like, then we can help you a bit more?
Murugesh PerumalAuthor Commented:
Hi Terry,

1.      Please refer attached Filter and Hyperlink.docx for the  table details. In that User need to filter only product type and Condition of the product. User should not filter on Product name and Image.
               Ex. User can filter the record which are all Product Type = Hardware and Condition = Good
              The user should not be allowed to filter on column Product name and Image (that is user cannot set filter as Product Name = mouse).

2.      For the Product name ‘Mouse’ we have three images  Mouse1.png, Mouse2.png, Mouse3.png  (with respective hyperlinks ) in a single cell. When the user wants to open the Mouse2.png image. how it can be done?

Can you give me a sample for having two or more hyperlinks in a single cell.
Murugesh PerumalAuthor Commented:
my conclusions  given below .

1.  Auto filter can’t be set to the alternative columns .

2.      It is not possible to set two hyperlink in one cell . It can be achieved by workaround method.
Step for the workaround method :
     a.      Place two rectangle control into a cell.
     b.Background and boarder of the rectangle need to be made as transparent.
     c.      Assign hyperlink1 to rectangle 1 and hyperlink2  to the rectangle2 (we can assign hyperlink by using macro also).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Murugesh PerumalAuthor Commented:
Auto filter can’t be set to the alternative columns  &  two hyperlink in one cell can be achieved by workaround method.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.