Certain Cells Appearing

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

 

[T. Valko]

See this:

http://contextures.com/xlautofilter01.html

 

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

 

[cts]

Thank YOU!

See this:

http://contextures.com/xlautofilter01.html

 

[cts]

THANK YOU!