Editing Drop down Combo boxes in Summary Sheet

I'm a bit of an excel novice, but enjoying learning the tricks of the trade.

I was kindly helped by another Forum member setting up a Summary page with dropdowns.

Since then i have really got to grips with things and I decided that i would add 'floating' drop down lists See <Product Summary (3)> and was impressed that i got them to function right by using the useful INDIRECT formula.

However there are a couple of problems i have. 1 minor 1 major.

I can't for the life of me work out how to change the look of the dropdowns. I want to make the font bigger and matching the rest of the text. I've searched and searched but can't find a solution. It's probably really simple, but not being an expert i thought i would ask!

Secondly, after setting up my ranges for the dropdown, i realised that the empty rows on the sheet (which will over time be filled in with new 'products') are displayed, so when you scroll down you can scroll through 10000s of blank rows. i thought i had solved this by limiting my range to the row under the current one. However when i add new items, i constantly have to keep changing the range so it all works. Is there a formula to make the range 'expand' on addition of a new row of active data?

Also, whilst i think about it, on the drop down boxes, is there a way of being able to type a little bit of text, which then filters the options ofr the drop down? For instance if i typed "rep..." the drop down would display all text similar to that?

Any help much appreciated

Paul