Can Excel do this...

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.

Pretty cool. I figured it out.

I used subtotals to count the # of employees per department, which is nice. It also allows me to open and close the department to see what I need. very cool.

Excel is awesome indeed.



Any tips on how to do good formatting? I think that is something good to learn.