|
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.
|