Solved

Default fonts for existing workbooks in Excel

Posted on 2014-03-27
3
6,472 Views
Last Modified: 2014-06-10
Is there a simple way of defining the standard font for an individual Workbook in Excel?

I use a number of old files that date from the days when MS Sans Serif was the standard font (which I can't stand).

The text I use in the file is mostly Arial but some Arial Narrow, however whenever I write in a blank cell somewhere in an unused portion of the sheet and then later delete all of the contents of that cell the font reverts back to MS Sans Serif.

Can I switch the background standard font of an individual file without having to select all of the blank cells?

(If I select all of the cells of course I then of course change fonts on cells I don't want to change).

Thankyou for any advice.
0
Comment
Question by:Glen_Sydney
  • 2
3 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
Comment Utility
Microsoft's help site states (see note on the linked page) that you can change the default font for excel but the change only applies to new files and not existing files. To change the default font for existing files you have to copy the existing sheet to a new file which has been created with the desired font.

http://office.microsoft.com/en-001/excel-help/change-the-font-or-font-size-in-excel-HP001216423.aspx
0
 

Author Comment

by:Glen_Sydney
Comment Utility
Thankyou, I thought that may have been the case.

I find that can get tricky when I have complex named ranges across multiple worksheets in the said file so tend to avoid doing this in case I leave any inks behind, but for simple worksheets it would be very straight forward.

Shame there was not a way without having to copy the sheets to a new file.
0
 

Author Closing Comment

by:Glen_Sydney
Comment Utility
Thankyou for your response.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now