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

Get FREE Advanced Excel Exercises with Solutions!

Using keyboards while working in Excel can increase efficiency and speed. It often saves time and reduces boredom. Changing the font size every time using a mouse could be time-consuming. In this article, we will show you how to increase font size using keyboard in Excel in 3 easy ways.


How to Increase Font Size Using Keyboard in Excel: 3 Easy Ways

In this article, we will demonstrate 3 easy methods to increase font size in Excel using a keyboard only. For this purpose, we will use the following dataset.

How to increase font size in Excel using keyboard


1. Use Format Cells Feature

In this method, we will use the Format Cells feature to increase font size in Excel. The steps are discussed below.

Steps:

  • First of all, select the cell and highlight the text you want to change the font of.

In this method, we will use the Format Cells feature to increase font size in Excel. The steps are discussed below. Steps: ● First of all, select the cell and highlight the text you want to change the font of.

  • Then press Ctrl+Shift+P Format Cells window will pop up.

Use format cell feature to increase font size in Excel using keyboard

  • Now press Alt+S buttons to activate the font size.

Use format cell feature to increase font size in Excel using keyboard

  • To increase the font size, use the down arrow key or simply type your desired font size.

Use format cell feature to increase font size in Excel using keyboard

  • After that, press Enter and you will get your text size in the increased font.


2. Apply One Step Shortcut

This is the quickest method to increase font size in Excel using a keyboard. We will show you the steps to follow the procedure.

Steps:

  • First, select the cell and highlight the text to increase the font.

  • Next, press Alt+H+F+G on the keyboard to increase the font size.
  • Here, Alt+H opens the Home tab and shows keyboard shortcuts for its features where FG is the key for increasing font.

Use one step shortcut to increase font size in Excel using keyboard

  • Therefore, pressing the F+G keys after Alt+H increases the text font size.

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


3. Run a VBA Code

This time we will run a VBA code using only a keyboard to increase font size in Excel. Read the following steps to learn how to do it.

Steps:

Run a VBA code to increase font size in Excel using keyboard

  • Then press Alt+F11 to open the Microsoft Visual Basic window.

Run a VBA code to increase font size in Excel using keyboard

  • Now we need to insert a new Module to write the code. To do that, press Alt+I+M.

Run a VBA code to increase font size in Excel using keyboard

  • Next, copy the following code using Ctrl+C and then paste it on the module using Ctrl+V.
Sub IncreaseFont()
    '
    ' IncreaseFont
    '
    ' Keyboard Shortcut: Ctrl+e
    '
        With Selection.Font
            .Name = "Calibri"
            .Size = 14
            .Strikethrough = False
            .Superscript = False
            .Subscript = False
            .OutlineFont = False
            .Shadow = False
            .Underline = xlUnderlineStyleNone
            .ThemeColor = xlThemeColorLight1
            .TintAndShade = 0
            .ThemeFont = xlThemeFontMinor
        End With
        Selection.Font.Bold = False
    End Sub

Run a VBA code to increase font size in Excel using keyboard

  • Press F5 to run the code and go back to the Excel file.
  • You will find the text in your desired font size.


Things to Remember

  • Press the right keys while following the steps. You won’t get the desired result even if you press just one wrong key.
  • While writing the code for the VBA method, you can add a macro shortcut key to run the code.

Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


Concluding Remarks

Thanks for making it this far. I hope you find this article useful. Now you know 3 easy methods to increase font size using keyboard in Excel. Please let us know if you have any further queries and feel free to give us any recommendations in the comment section below.


Related Articles

<< Go Back to Excel Fonts | Excel Cell Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Alif Bin Hussain
Alif Bin Hussain

Alif Bin Hussain earned a BSc in Civil Engineering from Bangladesh University of Engineering and Technology. As an engineering graduate, he has a deep passion for research and innovation. He loves to play with Excel. In his role as an Excel & VBA Content Developer at ExcelDemy, he not only solves tricky problems but also shows enthusiasm and expertise in handling tough situations with finesse, emphasizing his dedication to delivering top-notch content. He is interested in C, C++,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo