Hi Jonathan,

When I input a url into a box in excel and press enter to move to the box
below, it automatially creates a hyperlikn and chages the font from the
default value of 11 to 19.5.

I am happy that it creates a hyperlink but I do not want to have to keep
changing the font size back to 11.

Please can you help?

After you entered a hyperlink in a cell, do this:

Format, Styles, select Hyperlink from dropdown at top (if available, depends on
Excel version). Click Modify button, now set the font size needed and click OK
till you are back in Excel.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com