New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Double click a cell to switch to another cell and filters

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Double click a cell to switch to another cell and filters

Postby richignacio » Fri Mar 11, 2016 2:28 pm

Hello,
I downloaded the Excel template "Weekly Time Planner". It includes a feature where you double click on a Project cell and it takes you to the Tasks tab and filters out any tasks you have under that specific Project from the main Projects overview tab. Mine for some reason stopped working and I had to download another version twice already. My question is how do I assign a double click to a cell to reference and filter another cell in another tab? I think this is a very cool feature and I would like to learn how assign and use it. Any help would be greatly appreciated.

Kind Regards, Richard
  • 0

richignacio
Rookie
 
Posts: 1
Joined: Mar 11, 2016
Reputation: 0
Excel Version: 10

Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 251 guests