You might already know how to increase the size of the text or numbers that appear in your cells in Google Sheets, but you might find that the maximum option is too small for some situations. Luckily you can learn how to make font bigger on Google Sheets than the maximum point size that is shown in the drop down menu.
How to Use Larger Font Sizes in Google Sheets
- Open your spreeadsheet.
- Select your cell(s.)
- Click inside the Font size field, clear it, then type the new one.
Our guide continues below with additional information on how to make font bigger on Google Sheets, including pictures of these steps.
Google Sheets is an excellent alternative to Microsoft Excel for many users.
Most of the features that are commonly used in Excel are available in Sheets, and the ability to access your files and edit them directly from your Web browser is incredibly convenient.
But the programs are not identical, and you may have noticed some differences, some of which might be problematic for the way you make and edit spreadsheets. For example, the largest listed font size in Excel is 72 pt, which the largest listed font size in Google Sheets is 36.
However, like in Microsoft Office, it is possible to use larger font sizes by entering them manually. Our tutorial below will show you how to use larger font sizes in Google Sheets.
Wondering how to use the little numbers above or below your text in documents? Find out how to do subscript in Google Docs.
How to Go Bigger than 36 pt in Google Sheets (Guide with Pictures)
The steps in this article were performed in Google Chrome, but should work in other desktop Web browsers as well. The result of completing these steps will be a cell (or cells) with a font size larger than the 36 pt maximum that is listed in the font size dropdown menu.
Step 1: Go to your Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet file in which you would like to use a font size larger than 36 pt.
Step 2: Select the cell (or cells) of which you would like to change the font size.
Step 3: Click the Font size button in the toolbar above the spreadsheet, delete the current value, then enter the font size that you want to use.
Note that the largest font size you can use is 400.
Now that you know how to make font bigger on Google Sheets you will be able to apply this change to other spreadsheets that you make or edit which have text that is small or difficult to read.
Do you need to send a spreadsheet to someone, but you need it to be in the PDF file format? Learn how to save as a PDF from Google Sheets so that you can create the types of files that you need.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.