How to Change Font Size in Google Sheet

Author: Ritikaa | Guide: 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.

Google Sheets Tutorial Font and Font Size

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 of that particular Google sheet. After that, you just need to pace 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
Image Title Change Font size Step 1

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.

Image Title Change Font size Step 2

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 small 'Downward Arrow' as shown below.

Image Title Change Font size Step 3

Step-4 Select Your Preferred Size: A list of all the possible font size 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.

Image Title Change Font size Step 4

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.

Image Title Change Font size Step 5

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!

OPERATION SHORTCUT KEY
Clear text formatting Ctrl + \
Increase font size Ctrl + Shift + .
Decrease font size Ctrl + Shift + ,

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.

Was this article helpful ?

No