Glen_Sydney
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thankyou for your response.
ASKER
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.