Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 535
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Font color based on font type or size John Excel Discussion (Misc queries) 2 February 7th 08 12:50 AM
Stop URLs from changing font size - Excel 2007 dlee388 Excel Discussion (Misc queries) 2 November 14th 07 09:14 PM
How do I stop Excel from automatically changing font size? SK Excel Discussion (Misc queries) 0 June 22nd 06 03:13 PM
stop number font size from changing each time i click on somethin. alibob26 Charts and Charting in Excel 1 May 25th 05 03:15 PM
changing default font and size in Excel Ferd New Users to Excel 1 May 23rd 05 08:44 PM


All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"