Drill down in Excel ?

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 |
stevie's picture

yes it i, but

listerramjet |
listerramjet's picture

Or, a less sophisticated

non-sequitor |

Use a hyperlink

Martin Telfer |

I use hyperlink

Richard Willis |
Richard Willis's picture

Keyboard shortcut for precedents

shurst |
shurst's picture