Thread: MS Excel
View Single Post
Old 02-06-2008, 05:53 AM   #7 (permalink)
cohen
Diamond Member
 
cohen's Avatar
 
Join Date: Jan 2008
Location: Melbourne, Australia
Age: 14
Posts: 8,206
Thumbs up

Quote:
Originally Posted by Trizoy View Post
Excel is the correct tool for this, it is a very simple built in feature.

Highlight the row that you want your drop down menus on. From the Data Menu select Filter -> AutoFilter. That is all there is to it.

As Cosine said, that works in all versions.
See - it depends one what office you have on how to explain it.

Go:
1. - Highlight Cells
2. - Click on Data
3. - The Click filter

Bingo and done.
__________________
My Website
Desktop / Laptop
Motherboard: Asus M2N X SE / Unknown
CPU: AMD 4000+ 2.1GHZ x 2 / Intel Pentium M 1.60GHZ
Ram: 2GB Transcend / 512MB
Hard Drive: 320GB / 60GB
Video Card: Both Intergrated
Monitor: 19" Benq / 15.4"
OS: Windows Vista Home Premium Service Pack 1 / Windows XP Professional Service Pack 3
cohen is offline   Reply With Quote