...

• Select () from the quick action bar to invoke the interactive filter
• Select 43. CHR Gender for Column 

For categorical columns, the interactive filter displays each category of the selected column as a colored bar. For 42. CHRGender, each bar represents a chromosome with the height of bar representing the number of probes from that chromosome in the selected spreadsheet. To filter out a category, left-click on its bar. Right clicking on a bar will include only the selected category. A pop up balloon will show the category label as you mouse over each bar. 

• Left-click the X and Y chromosome columns  Male column to filter them it out (Figure 35)
  
  

Image Removed

The yellow and black bar on the right-hand side of the spreadsheet panel shows the fraction of excluded cells rows in black and included cells rows in yellow. Right-clicking this bar brings up an option to clear the filter. 

Now that we have filtered out probes on the X and Y chromosomesmale samples, we will create a spreadsheet containing only probes on the autosomesfemale samples. 

• Right click on the ANOVA-1way 1 (ANOVAResultsMethylation) spreadsheet in the spreadsheet tree panel (Figure 4)

• 6)
  
  

• Select Clone
• Rename the new spreadsheet Female_only using the Clone Spreadsheet dialog
• Select 1 (Methylation) from the Create new spreadsheet as a child spreadsheet: drop-down menu (Figure 7)
• Select OK
  
  

• Specify a name for the spreadsheet, we chose female_only, using the Save File dialog
• Select Save to save the spreadsheet

It is best practice to occasionally save the project you are working on. Let's take the opportunity to do this now. 

• Select File from the main command toolbar
• Select Save Project...
• Specify a name for the project, we chose Methylation, using the Save File dialog
• Select Save to save the project

Saving the project saves the identity and child-parent relationships of all spreadsheets displayed in the spreadsheet tree. This allows us to open all relevant spreadsheets for our analysis by selecting the project file. 

...