How to Change Font Size in Excel (4 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Excel provides one-stop solutions to their customers. For example, there are a number of fonts with default size if you wish to work with them. However, sometimes you may have to change your font size according to your work type. How will you do that? To make your task easy, today we will learn 4 easy ways to change font size in Excel.


Download Practice Workbook

You can download and practice the dataset that we have used to prepare this article.


4 Effective Ways to Change Font Size in Excel

Let’s assume we have a dataset, namely “Employee Vacation Time Tracker”. You can use any dataset suitable for you.

Employee Vacation Time Tracker

Here, we have used the Microsoft Excel 365 version; you may use any other version according to your convenience.


1. Utilizing the Ribbon

Changing the font size is not a hard task only if you know the tricks. Here we are going to show an easy method in which we utilize the Ribbon.

📌 Steps:

  • Select the cell containing the text you want to change.
  • Click on the Down Arrow, next to the size box on the Format Bar.

Utilizing the Ribbon

  • Or you may proceed with the highlighted box to increase or decrease your font size.

Utilizing the Ribbon

  • Now, there are a ton of different text size numberings in ascending order. You can choose your size accordingly.

Utilizing the Ribbon

  • Here we have chosen font size 10 and the corresponding result is given below.

Utilizing the Ribbon

Read More: How to Change Font in Excel to All Caps (6 Simple Ways)


2. Using Shortcut Key

In Excel, you can change your font size by simply following the above-mentioned method. However, how would you handle the situation in Excel if you simply wanted to change by using a few shortcut keys? Well, here we are going to demonstrate two shortcut keys in this regard.

📌 Steps:

  • Select your intended cell where your data reside.

Using Shortcut Key

  • Now, press the Alt + H keys together. Thus, your tab list will appear as shown in the below screenshot.

Using Shortcut Key

  • Press the F + G keys on the keyboard simultaneously to increase your font size.
  • Or, press the F + K keys to decrease your font size. Here, the output is shown by decreasing the font from 12 to 11.

Using Shortcut Key

Read More: How to Increase Font Size Using Keyboard in Excel (3 Easy Ways)


3. Employing a Cell Style

You can accomplish the same task by employing a specified Cell Style available in Excel. It is to be noted that it will increase or decrease every font in our Excel file, irrespective of selecting a specific region.

📌 Steps:

  • First, select Home > Cell Styles > Normal
  • Click on the right button on your mouse.
  • Then click the Modify option.

Employing a Cell Style

  • Click on the Format.

Employing a Cell Style

  • Select the Font tab, then choose any of the font sizes you wish to proceed with.
  • Press OK afterward.

Employing a Cell Style

  • Thus, the dialogue box will disappear.
  • Now press OK.

Employing a Cell Style

  • Here is our output with a font size of 14.

Employing a Cell Style

Read More: How to Change Font Style in Excel (6 Easy Methods)


4. Incorporating VBA Code

The shortcut key we have used in Method 2 is rigorous to some extent. There is a limitation as it changes the size of only 1 scale at a time. So, you have to follow the method over and over to get your desired output. Instead of that, you can create your own shortcut key by incorporating VBA code.

📌 Steps:

  • Press Alt + F11 to open your Microsoft Visual Basic.
  • Then press Insert > Module to open a blank module.

Incorporating VBA Code

  • Now, write the following VBA code in your Module1.
Sub FontIncreaser()
    Selection.Font.Size = Selection.Font.Size + 1
End Sub
Sub FontDecreaser()
    Selection.Font.Size = Selection.Font.Size - 1
End Sub

Incorporating VBA Code

Code Breakdown:

Now, we will explain how the given VBA code works. The code is divided into 2 steps.

  • In the first portion, the function named FontIncreaser gives an increment of 1 to the Size property. If you want your shortcut key to make work faster, you may put +2/+3 in that place.
  • In the second portion, the function named FontDecreaser gives the decrement of 1 to the Size property. If you want your shortcut key to make work faster, you may put -2/-3 in that place.
  • Close your VBA window.
  • Click on Developer > Macros.

Incorporating VBA Code

  • This will open the Macros dialog box. Then select your function, which in this case are FontDecreaser & FontIncreaser. First, click on FontDecreaser. Then press the Options button.

Incorporating VBA Code

  • Create your own shortcut key here. We have chosen Ctrl + s as our shortcut key to decrease the value. You can choose any alphabet if you wish.
  • Then, press OK.

Incorporating VBA Code

  • Again, click on FontDecreaser then press the Options button.

Incorporating VBA Code

  • To increase the font size, we choose Ctrl + b as our shortcut key. Again, you can choose any alphabet if you wish.
  • Then, press OK.

Incorporating VBA Code

  • Choose the range for which you want to change the font.
  • Press the customize shortcut key Ctrl + s to decrease your font size or Ctrl + b to increase

Incorporating VBA Code

Read More: How to Change Default Font in Existing Excel Workbook


How to Increase Font Size in Excel for Printing

There are several methods to increase the font size in Excel for printing. However, we are going to show you a simple technique below.

📌 Steps:

  • First, go to the File menu.

How to Increase Font Size in Excel for Printing

  • Select Print > No Scaling.

How to Increase Font Size in Excel for Printing

  • Next, hit on Custom Scaling Options.

How to Increase Font Size in Excel for Printing

  • Thus, a Page Setup window will appear.
  • In the scaling option, it shows a default size that is 100% of the normal size.
  • What it means is that the printed font size will be equal to the font size shown in the Excel spreadsheet.

How to Increase Font Size in Excel for Printing

  • From the preview image, you can see how the printed copy will look like.

How to Increase Font Size in Excel for Printing

  • Now to change from its default mood, enter 130% for instance.
  • Thus, your printed image will be 1.3 times higher than the previous version.
  • Press OK afterward.

How to Increase Font Size in Excel for Printing

  • So here is our final output given below.

How to Increase Font Size in Excel for Printing


Conclusion

In this article, we have tried to describe four easy ways to change the font size in Excel. This is an easy task, and we should learn these methods to make our lives a little bit easier. Further, if you have any queries, feel free to comment below and we will get back to you soon.


Related Articles

Tags:

Mohammad Shah Miran

Mohammad Shah Miran

Miran is a highly motivated individual with a strong educational background in engineering. He is interested in technology and passionate about creating engaging and informative content. After graduation, Miran decided to pursue a career in content development and has been working in the field for some time. He is eager to continue learning and growing as a professional.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo