Changing the Standard Font

Apart from the standard font style and font size in Microsoft Excel, there are various font style and different font size available. In this article, you’ll learn how we can change the standard or default font style and size in Microsoft Excel.

We have 2 ways to change the standard font:-

  • Temporary Change
  • Permanently change


How to change the font temporarily?

Let’s understand with a simple example:- We have prepared a sales report in which we want to show heading extra-large to the standard size and some where we want to change the font style.

image 1


First we will change the font style, follow below given steps:-

  • Select the heading
  • Go to Home tab
  • Under the font group you will find the option of font style option

image 2


  • From the list you can select any font style that will be applicable only for selection

image 3


Now we will change font size follow below given steps:-

  • Go to Home tab > Font group > Font Size

image 4


  • Select any font size that would be applicable only on selection

image 5


In the above image you see that we have changed font size and font style only for selected cell.

How to change the font permanently?

Follow below given steps:-

  • Click on file tab
  • Click on Excel options
  • In the General option we can change the font style and size permanently

image 6


  • After changing the standard font style and font size click on OK
  • When you will open new worksheet selected font style and size will work as standard font size and style

image 48


If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.