Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop URLs from changing font size - Excel 2007
Can anyone please tell me how to stop Excel 2007 from changing the font size
every time I type a URL into a cell. I'm using a spreadsheet to track a number of URLs that I'm creating for my job. The default font size for the worksheet is 12. Everytime I type a URL into a cell, Excel converts it to font size 7. Then I have to change the font size back to 12. I'm tracking a lot of URLs and this is getting old. I spent a fair amount of time reading online help, google results, Microsoft's site, and some forums without finding an answer. I would greatly appreciate any advice. Regards, dlee388 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop URLs from changing font size - Excel 2007
When Excel 2007 detects a hyperlink is entered it automatically applies the
Hyperlink style to it. When a hyperlink is clicked it applies the Followed Hyperlink style. You can change the definitions of these styles by clicking Cell Styles on the Home tab, Styles group, and then right clicking them and picking Modify. This change only affects the active workbook however. -- Jim "dlee388" wrote in message ... Can anyone please tell me how to stop Excel 2007 from changing the font size every time I type a URL into a cell. I'm using a spreadsheet to track a number of URLs that I'm creating for my job. The default font size for the worksheet is 12. Everytime I type a URL into a cell, Excel converts it to font size 7. Then I have to change the font size back to 12. I'm tracking a lot of URLs and this is getting old. I spent a fair amount of time reading online help, google results, Microsoft's site, and some forums without finding an answer. I would greatly appreciate any advice. Regards, dlee388 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop URLs from changing font size - Excel 2007
Thank you. That did it. I did try looking in Cell Styles before I posted
this question and I didn't see that Hyperlink cell style because the font was so small. "Jim Rech" wrote: When Excel 2007 detects a hyperlink is entered it automatically applies the Hyperlink style to it. When a hyperlink is clicked it applies the Followed Hyperlink style. You can change the definitions of these styles by clicking Cell Styles on the Home tab, Styles group, and then right clicking them and picking Modify. This change only affects the active workbook however. -- Jim "dlee388" wrote in message ... Can anyone please tell me how to stop Excel 2007 from changing the font size every time I type a URL into a cell. I'm using a spreadsheet to track a number of URLs that I'm creating for my job. The default font size for the worksheet is 12. Everytime I type a URL into a cell, Excel converts it to font size 7. Then I have to change the font size back to 12. I'm tracking a lot of URLs and this is getting old. I spent a fair amount of time reading online help, google results, Microsoft's site, and some forums without finding an answer. I would greatly appreciate any advice. Regards, dlee388 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop the font from changing colour automatically? | Excel Discussion (Misc queries) | |||
Stop Excel 2007 from Changing Column Widths | Excel Discussion (Misc queries) | |||
How do I stop Excel from automatically changing font size? | Excel Discussion (Misc queries) | |||
stop number font size from changing each time i click on somethin. | Charts and Charting in Excel | |||
changing default font and size in Excel | New Users to Excel |