Need to know how to change the Default Font/Color change when creating a hyperlink within a cell

[Mr. Walnuts]

Embarrassing,

but I have a report due tomorrow and all I havve remaining is typing the links in the cells.

The range I'm using has the text formatted to Georgia 9.5px (black)...

I do not mind the hyperlinks turning blue, in fact, I expected it; However, the cell sizes do not accommodate calibri 11px as the cells only have a width of 23 (260 pixels).

Does anyone have the procedure for changing the default hyperlink font format (the size, font, color, etc text turn once they become hyperlinks?


Additionally... but less important...
Can anyone tell me how to change that ugly default calibri font Excel went with back to something normal when opening a new workbook?... Something like Navy



Even Less Important: How do you change the default number of worksheets in a new workbook and the default formatting in those workbooks?



If possible, please answer Question #1 first... I'm on a 15 hour deadline

 

[JackDanIce]

For Excel 2007, on the home tab, go to the group Styles and in there, on the 4th column, near the bottom are two selections:

Hyperlink 2 and Followed Hyperlink 2

Right click on whichever one you want and you'll see an option to modify, this should allow you to change to suit your needs

 

[beirrac]

For the hyperlink, right click on hyperlink, select Format Cells from the menu, select font tab to change font.

To change the number of pages and the default font for new workbooks, select file, options, general. You will see the items you want to change. Must restart excel to take effect.

 

[Mr. Walnuts]

Wow, so its not like the older versions where you had to make templates and save them in a specific directory so that every new workbook opened pre-formatted to you specifications?


Thank you for your help.