| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL | Excel Discussion (Misc queries) | |||
| #REF appearing when cells,rows,cols are all protected | Excel Discussion (Misc queries) | |||
| Excel: How to stop '#div/0!' from appearing in empty cells. | Excel Discussion (Misc queries) | |||
| I want my cells to stop appearing in an outline format | Excel Discussion (Misc queries) | |||
| Hidden Cells Keep Appearing | New Users to Excel | |||
Linear Mode
