How To: Change the Default Font in Excel 2010

Change the Default Font in Excel 2010

Some people may don't like the default word or hyperlink font in their Excel. Though you can change the word font of the whole sheet by using the font tools in the Home menu, but the default font still remains when you create a new Excel file. So, here is the solution.

Step 1: Click the Cell Styles Under the Home Menu

Open an Excel, click Home > Cell Styles.

Step 2: Right-Click "Normal"

To change the default font of normal words, right click Normal .

Step 3: Click "Modify"

Step 4: Click "Format"

Step 5: Then Choose the Font Your Like

In the Font tab, you can choose your font, font style and size for the normal words in the Excel sheet. Click OK to confirm it.

Wanna change the hyperlink font? Click Cell Styles, right-click Hyperlink, then the following steps are the same as changing normal words.

Then, next time you create a new sheet, the font will be what you've set last time.

Extra Tip

You can also try this method. Click File > Options > General. And change the font.

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest