How to Change Font Size in Google Sheets

Do you know that you can change the font style in sheets? Along with that, change the font size too in your Google sheet! Make your font smaller or larger whatever looks good on your sheet. This feature is helpful in making the text and information distinguishable. Let's dive into the article to learn more about it.

How to Change the Default Font in Google Sheets

Change Font Size in Google Sheet in 5 Steps

Step-1 Navigate to Your Google Sheet: You can open a fresh Google sheet or reopen an existing one. There are 2 ways to do this as follows:

• If you wish to open an existing Google sheet, then you will need the link to that particular Google sheet. After that, you just need to place the link in your web browser and click on search to open it up.
• Or, you can also consider reopening the Google sheets website on your web browser if you want to create a new one

Step-2 Select The Cell To Change Font Size: Then, you have to select the cell in which you want to change the size of the font and then click on it.

Step-3 Click As Shown: you can find the 'Change Font size' option in the picture given below.

Most of the time, the default font size is set to 11. You have to click on the small 'Downward Arrow' as shown below.

Step-4 Select Your Preferred Size: A list of all the possible font sizes will now open up after clicking on the arrow.

You can select the size of your font. You can also try out different font sizes by clicking on them one by one.

Step-5 Font Size is Finally Changed: After choosing the perfect font size for your text, you can easily apply it. Like you can also see in the picture below how the text 'MUMBAI' has a larger font size than the rest of the values in the same column.

FAQ

How Can I Change the Font Size in Google Sheets with Keyboard?

If you do not want to use the traditional method to change the font size in your Google sheet, then you can take the help of the following shortcut keys!

How Can I Increase Font Size in Excel Spreadsheets?

To increase font size in your Excel spreadsheet, do the following:

• Open your spreadsheet.
• Go to the 'File' tab.
• Then, click on 'Options'.
• In the dialog box that appears, choose the 'General' option.
• In the 'When creating new workbooks', go to the 'Font Size box'.
• Here, you have to enter the font size you want.
• Then, click on 'OK'.

You can also download files in Excel format.

How Can I Resize in Google Sheets?

To use the 'Resize' function in Google Sheets, do the following:

• Access your Google sheet first.
• Then, select a row or column to resize.
• You can also highlight multiple rows or columns.
• Now, just right-click the row number or column letter.
• Then, you can either click on 'Resize row' or 'Resize column', whatever you want to resize.
• Then, fill in the 'Enter a custom height or width' option.
• Finally, tap on 'OK'.

What is 'Ctrl+E' in Google Sheets?

In Google Sheets, the shortcut key 'Ctrl+E' is nowhere related to the resize function.

The function of this shortcut key is to collapse an array that has been expanded previously.

How Can I Enlarge the Font on Google Webpage?

• Open your 'Chrome web browser.
• Click on 'More' from the top right side.
• Then, click on 'Settings'.
• Now, tap on 'Appearance'.
• Next to the 'Page zoom' option, click on the 'Down arrow'.
• Then, choose the zoom value you want to enlarge the text on the webpage.

Another Method

Nobody likes to read text that has too large or too small fonts. It is just not feasible for the eyes. To overcome that, you should change the font size in google sheets so the data is easily readable. So, changing the font size is just for readability. Not really. You can separate titles from the data, highlight the specific columns, give emphasis on particular data, and so on by changing the font size. So, without further ado, let's get going with the steps. Read on to see the example of the usage of the font size.

Change Font Size in Google Sheets: 4 Steps

Step-1 Open Google Sheets Application: On your mobile device, look for the icon of the google sheets app. It is a green sheet of paper having a little fold on the top-right corner. It has white outlined cells over it. Cannot find it?

• Go to the play store application on your mobile device.
• In the search bar, type in 'Google Sheets.'
• Look or the described icon.
• Once you find it, click on install and let it download. Open it afterward.

Step-2 Tap on Any Cell: On opening the google sheets application, there is a list of your shared and created documents. Select the one you want to work on.

• You can even create a new spreadsheet or make a google sheet template. 
• Once you open a document, click on any cell to change the font size of the text.

Step-3 The 'A' Icon: By clicking on any cell, two formatting toolbars appear on the top and the bottom of the screen. The options to edit and format the sheets appear along with it.

• In the topmost toolbar, you see an icon of capital 'A'.
• It is almost at the center of the bar. It even has horizontal lines at its side that decrease in length from top to the bottom.
• Click on it to go further.

Step-4 Tap on the Size: The 'A' icon opens up a box at the bottom of the screen. It has two categories. One is for text editing and the other is for cell formatting.

• Since changing font size is related to text editing, our answers lie in this category itself which is selected by default.
• On scrolling a little further, you see the option of size just below the alignment options.
• The size option has upward and downward arrow keys on the right end.
• Between these arrows is a number that is the current font size.
• Use the downward arrow key to decrease the size and the upward arrow key to increase the size.
• Thus, you can change the font size like this.

Now, let us understand the utility of changing the font size. For instance, you are creating a google sheet calendar. Now if the name of the months, the name of the days, and the dates, all are in the same font size, it will be tough to make out easily. The readability of such a calendar is low. So, you can keep a larger font size for the title of the month, a little smaller for the days, and smaller than that for dates.

• So, it can be like Months in size 16, days in 14, and dates in 12.
• Try this out and see how changing font size enhances the visibility of any google sheet.