ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I stop excel changing the font size when I enter a url? (https://www.excelbanter.com/excel-discussion-misc-queries/258490-how-do-i-stop-excel-changing-font-size-when-i-enter-url.html)

Jonathan R. Tuck

How do I stop excel changing the font size when I enter a url?
 
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?

Jan Karel Pieterse

How do I stop excel changing the font size when I enter a url?
 
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



All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com