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.
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.
- Select the cell containing the text you want to change.
- Click on the Down Arrow, next to the size box on the Format Bar.
- Or you may proceed with the highlighted box to increase or decrease your font size.
- Now, there are a ton of different text size numberings in ascending order. You can choose your size accordingly.
- Here we have chosen font size 10 and the corresponding result is given below.
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.
- Select your intended cell where your data reside.
- Now, press the Alt + H keys together. Thus, your tab list will appear as shown in the below screenshot.
- 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.
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.
- First, select Home > Cell Styles > Normal
- Click on the right button on your mouse.
- Then click the Modify option.
- Click on the Format.
- Select the Font tab, then choose any of the font sizes you wish to proceed with.
- Press OK afterward.
- Thus, the dialogue box will disappear.
- Now press OK.
- Here is our output with a font size of 14.
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.
- Press Alt + F11 to open your Microsoft Visual Basic.
- Then press Insert > Module to open a blank module.
- 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
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.
- 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.
- 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.
- Again, click on FontDecreaser then press the Options button.
- 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.
- 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
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.
- First, go to the File menu.
- Select Print > No Scaling.
- Next, hit on Custom Scaling Options.
- 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.
- From the preview image, you can see how the printed copy will look like.
- 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.
- So here is our final output given below.
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.