Drill down in Excel ?

Posted by jpcc1 PM | on Thu, 03/11/2011 - 10:16 4440 6 comments | report

Is there any way I can create a drill-down in Excel, so that I can click on a cell in a summary sheet and it takes me automatically to the detail elsewhere in the workbook? (I'm using Excel 2003).

Many thanks, in anticipation

Comments

There are 6 comments. Login or register to view them.

Use pivot tables

stevie | Thu, 03/11/2011 - 10:40

yes it i, but

listerramjet | Thu, 03/11/2011 - 11:52

Or, a less sophisticated

non-sequitor | Thu, 03/11/2011 - 11:53

Use a hyperlink

Martin Telfer | Thu, 03/11/2011 - 12:19

I use hyperlink

Richard Willis | Thu, 03/11/2011 - 14:38

Keyboard shortcut for precedents

shurst | Fri, 04/11/2011 - 11:00