• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 10682
  • Last Modified:

Default fonts for existing workbooks in Excel

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
Glen_Sydney
Asked:
Glen_Sydney
  • 2
1 Solution
 
Saqib Husain, SyedEngineerCommented:
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
 
Glen_SydneyAuthor Commented:
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
 
Glen_SydneyAuthor Commented:
Thankyou for your response.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now