I have to put the zoom size of me worksheet to 75% to see the complete page.
With this, the font size on the various drop down menus gets smaller.
Is there any way to increase the font size temporarily while selecting the options in drop down menu?

Thanks in advance

No. Sorry, a common complaint. You can redesign your worksheet to use combo boxes from the Control Toolbox toolbar, a lot more work to setup but you at least have control of font sizes in that approach.

Excel -- Data Validation -- Tips and Quirks (http://www.contextures.com/xlDataVal08.html#Font)

Excel -- Data Validation -- Combo box (http://www.contextures.com/xlDataVal10.html)

Thank you for your prompt reply. I will try with combo box.