LinkBack URL
About LinkBacks
How do I change the default font in an existing workbook?? Must be so simple I am stupid...
How do I change the default font in an existing workbook?? Must be so simple I am stupid...
Change the font for style Normal.
Entia non sunt multiplicanda sine necessitate
I have tried that but every worksheet I creates go back to the silly font I created it with.
Once you change some aspect of the formatting of a cell, changes to the underlying style won't be reflected. Select all the cells and change to style Normal, then go from there.
If the undesired fonts appear in new workbooks then,
Excel Options > Popular, When creating new workbooks -- change the font face and size.
If you have Book.xltx and Sheet.xltx in your XLSTART folder, change the font of style Normal in those.
Last edited by shg; 11-18-2013 at 11:40 AM.
Yeah. That is what I am doing. Thank you.
Re: Changing default font in existing workbook
omg Thank you! This has been bugging me for like a YEAR!Originally Posted by shg
Every time i created a new worksheet in an existing workbook i was stuck with it reverting the font to Times New Roman when i need it to be a monospaced font like Consolas. Changing the Normal style worked!
IDK why this didn't occur to me sooner but it just goes to show even with decades of excel experience you can't remember everything at once. lol
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks