View Single Post
  #3   Spotlight this post!  
Unread 04-01-2006, 02:28
Dave Scheck's Avatar
Dave Scheck Dave Scheck is offline
Registered User
FRC #0111 (WildStang)
Team Role: Engineer
 
Join Date: Feb 2003
Rookie Year: 2002
Location: Arlington Heights, IL
Posts: 574
Dave Scheck has a reputation beyond reputeDave Scheck has a reputation beyond reputeDave Scheck has a reputation beyond reputeDave Scheck has a reputation beyond reputeDave Scheck has a reputation beyond reputeDave Scheck has a reputation beyond reputeDave Scheck has a reputation beyond reputeDave Scheck has a reputation beyond reputeDave Scheck has a reputation beyond reputeDave Scheck has a reputation beyond reputeDave Scheck has a reputation beyond repute
Re: Controlling visibility of cells in Excel

Have you tried the Auto Filter feature? Here's a quick example.

Set up two columns with headers, Angle and Force seem like what you have. Once you have all your data entered, select the columns. Now click on Data->Filter->AutoFilter.

You should now have drop down menus in your header cells. Based on what you were asking, you'll want to select the "Custom" option from the Angle drop down. You'll get a dialog where you can enter your filtering criteria. When you enter your query, the rows that don't match will be hidden and the row numbers for the matching rows will be blue.

To get all of your data back, select the "All" option from the drop down.

To remove the drop downs, click Data->Filter->AutoFilter again.

What I like best is that it allows you to filter based on multiple columns. I use this a lot at work when I need to dig through data logs. I can very quickly show all messages of a certain type that occurred in a certain time interval.

Play around with it a little bit, it should be fairly intuitive.

Hope this helps.