Import+and+Filter


 * Search keywords:** Excel Hints. Heelo Mum!


 * Import a web query**
 * Browse web for relevent site and copy URL (web address)
 * Click in cell A1
 * Data menu, import, import web query
 * Paste in URL (Ctrl V)
 * Click Import
 * Follow wizard to end


 * Import a .csv**
 * Click in cell A1
 * Data menu, import, import external data
 * Browse to the file
 * In wizard step 2 tick comma box
 * Follow wizard to end


 * Insert Auto Filter**
 * Highlight columns
 * Data menu, Filter, Auto Filter
 * Click on a down arrow to filter by a column
 * Click on All, to bring back all data
 * HINT: if row numbers blue, you still have a filter on