Certain Cells Appearing

C

cts

I am trying to create a spreadsheet that would only display certain
information. For example student name, id, grade level? Since I have multiple
students, grade levels, etc. How can I make it where if I only want seventh
grade to appear with all the students in seventh grade, etc.
 
J

Jim Cone

Auto Filter will do exactly that. Find it on Data (menu) | Filter
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - no registration required)



"cts" <[email protected]>
wrote in message
I am trying to create a spreadsheet that would only display certain
information. For example student name, id, grade level? Since I have multiple
students, grade levels, etc. How can I make it where if I only want seventh
grade to appear with all the students in seventh grade, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Representing letters (and symbol) to different numbers 4
Calculating an average of data between two dates 1
Saving a value in another cell 1
COUNTIF 7
Adding cels in a row that correspond to the heading of a column 2
problem with a function to calculate weighted test score 2
Copying Cell from Multiple Worksheets to a Summary Worksheet 4
Integrating information from Word to Excel (not mail merge) 1

Top