Hello everyone.
pretty new to excel, but having blast learning it.

Anyway, i am putting together a Excel file that is going to hold all the username's and passwords for our company employees (it will be password protected ).

Anyway, I was trying to come up with some creative ways to make this spreadsheet with some of the cool tips I learned from Books and web resources.

First, is it possible in excel to do something so if I divide the worksheet into sections (for each department) everything is hidden, unless I pick a specific department? Then it would display only those users and their passwords?

Trying to get creative here. Suggestions are welcome.

Cheers.