I am trying to set up a diary filter on a vertical drop down column but i cannot seem to make it work! how frustrating. I have highlighted the whole column and have gone to format the cell but even when i apply this the diary doesn't seem to go past a few rows below the top of the spreadsheet. Can anyone help???