Creating explorer bar in Excel

[Excelboy_01]

Hello people,

I am stuck and desperately need your help.

I am trying to make an explorer bar for excel instead of having a huge excel sheet. i.e. Say I have an excel sheet (EDUCATION) with about 30 columns (could be bigger). The first 10 for University, following 10 for High School, and the other 10 Primary school. Instead of seeing the whole sheet at once, I would like to be able to separate them in form of Explorer bar., so that I click on University, if shows me information for Uni only, likewise for High school and P.School.

Thanks in advance

 

[Hamburgler]

Have you looked at the AutoFilter (FILTER) or GROUP/UNGROUP features in the DATA tab?

 

[Excelboy_01]

Thanks for the tip, but I need it to be shown as explore bar not simply filtering them out