Stop URLs from changing font size - Excel 2007

G

Guest

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
 
J

Jim Rech

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top