Simple clear advice in plain English

Can I fix the font in Excel?

It is possible to set a default font for every time you make a new spreadsheet in Microsoft Excel 2003, 2007 and 2010

Font changing options in Excel
You can change the preferred font in Excel, but not across Windows

Q I have an HP 310-1220 PC running Windows 7. I use the 2007 version of Microsoft Office. Every time I use Excel, I have to reset the font to my preferred style of Times Roman. I also have to adjust the size. At some point in the past I successfully managed to fix my favourite font in Word but this apparently had no effect on Excel. Is there a Windows setting to fix a default font so all my words can be produced in Times Roman? Or is there at least a way to fix Excel’s font?
Roger P

A Though we think it’s a nice idea, there isn’t a single Windows setting that will fix the font and size across every application, and nor would it be practical: developers like the freedom to mould their programs in whatever way they choose (10-point Times Roman might look a little odd in a fast-paced shoot-’em-up game, for example).

Read more: Reader questions | PC Help

However, it is straightforward to fix the font in Excel. To do this in the 2007 version, first click the Microsoft Office button (at the top left of the application window) and choose Excel Options. In the Options dialogue box, click the Popular category on the left-hand side and make your choices using the dropdown menus under the ‘When creating new workbooks’ section. Click OK to finish. This same technique applies to Excel 2010 as well.

For the benefit of readers still using Excel 2003, first open the Tools menu and choose Options. Now click to select the General tab and then use the Standard font and Size dropdown menus near the bottom of the dialogue box to make your choices.

Reader Comments

   

Add your comment

Please keep comments constructive and free from abuse of any kind and swearing. If you wish to link to a product or service online, please do so in such a way that makes it clear that it is not spam. If you are connected to any such product you should make that clear.

We may use your comments in the magazine. We may edit your comments for clarity or to remove unacceptable material. We will attribute your comments but not share your email address.

We request your email address and record your Internet Address (IP address) in order to block spam from our site. We will never share this information without your permission.

All comments are reviewed by the Computeractive Team before being published. Please bear with the slight delay this causes, you don't need to post more than once.

Click here to read our Privacy Policy

Click here to read our site Terms & Conditions

Related articles

Excel error screenshot

Why do some of my Excel cells show a '#VALUE!' error?

The error message a reader is getting is because he may have typed a space in the cell, which is confusing Excel when doing the spreadsheet calculations

Reverse formatting

Reverse red formatting in Excel

Format spreadsheets so you are alerted with red text when you go over budget

Format Excel columns

How can I centre titles in Excel?

It is more flexible to use the Format Cells window, rather than choosing the Merge and Centre option when adding titles that run over several Excel cells

Content Recommendation

Question & Answer

Q.Why is Windows Backup skipping files?

> Read the answer

Q.Why do my scanned documents display gibberish?

> Read the answer

Q.How can I convert MTS files to edit in Windows Movie...

> Read the answer

Best deals on the web

img

Three Huawei E5331 1 Month Rolling Contract Mobile WiFi

£29.99- Buy it now

img

O2 Pay As You Go Micro SIM Card

£0.99- Buy it now

img

Carcomm Active Mobile Phone Cradle for HTC S710 / Orange SPV C650 / Vodafone Vda V

£49.99- Buy it now

Updating your subscription status Loading

Most popular articles

No matching document

Poll

Do you have Windows 8?

Jargon Buster

Computing terms explained in plain English

VGA

Video Graphics Array. Standard socket for connecting a monitor to a computer.

Great shopping deals from Computeractive

Information currently unavailable