Certain Cells Appearing
 

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.

Certain Cells Appearing
 

See this:

http://contextures.com/xlautofilter01.html

--
Biff
Microsoft Excel MVP


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

Certain Cells Appearing
 

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

Certain Cells Appearing
 

Thank YOU!

"T. Valko" wrote:

See this:

http://contextures.com/xlautofilter01.html

--
Biff
Microsoft Excel MVP


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

Certain Cells Appearing
 

THANK YOU!

"Jim Cone" wrote:

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