Forum Discussion
Default Font in Excel
I have my Default Font as Arial (12) in Excel. I want this set for ALL cells. However, anything viewed as a web address or email automatically defaults to Calibri (11) as a Hyperlink. Is it possible to change that setting?
7 Replies
I used Excel Options to set the default font to Consolas 14 pt.
[The reason for this choice was that I was more interested in displaying multi-line formulas using a non-proportional font than I was in compact or pretty text output]
JMMed55 - What I've done to save the default Excel worksheet font I like (Arial Narrow/12) is to just open a new Excel Worksheet on my Desktop> change the font > Save > close the un-named worksheet > Drag it to the taskbar (pinning it) > Delete the saved worksheet on my Desktop (I hate documents on my Desktop, I only use shortcuts to currently working projects) > Yer DONE - Open a new Excel worksheet from the newly pinned Excel icon and you will see your new Excel Worksheet ready with your fav font in play.
- Open a blank, one-sheet workbook. Click the styles gallery and right-click the Hyperlink style (if it isn't there, insert a hyperlink in a cell) and choose Modify. Now change the font to your liking.
Remove everything you don't like.
Set any other features you prefer, such as headers and footers, gridline display, etcetera.
Save as the workbook using this name (file type Excel template *.xltx):
book.xltx
and save it in this location (type in save-as box and press enter):
%appdata%\microsoft\excel\xlstart- Thanks, it did default to my preferred Font and Font size, but it still creates a hyperlink, and changes the Font Color. I don't want to create ANY Hyperlinks, and stay the same Font Color and when I populated the cell
- Yes, when you insert a hyperlink, Excel changes the cell style to Hyperlink. There is nothing you can do against that I'm afraid.
I don't recommend to remove the underline, it makes it clear there is a link there.
