Link to home
Start Free TrialLog in
Avatar of Glen_Sydney
Glen_SydneyFlag for Australia

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Glen_Sydney

ASKER

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.
Thankyou for your response.