Google Sheets doesn’t currently offer a global default font size, but you can resize a whole sheet in seconds. Press Ctrl + A (Cmd + A on Mac) to select all cells, then set the size in the toolbar’s font size box. To change the default font family for a file, go to Format > Theme > Customize and pick a font. To reuse your settings, make a copy of a formatted file or save it as a template. New files start with Arial, size 10.

Change the Font Size for the Whole Sheet
- Click any cell, then press Ctrl + A (press twice if the first press selects only a data region), or click the gray box at the top-left corner of the grid.
- In the toolbar, click the font size box and type or pick a size, such as 12. You can also use the − and + buttons.
- Repeat for other tabs if needed; each sheet tab is formatted separately. Select multiple tabs by Ctrl-clicking them to apply formatting to several at once.
Does changing the size affect printing?
Yes. Larger fonts may push content onto more pages; check File > Print and use Fit to width if needed.
Change the Default Font Family with a Theme
- Click Format > Theme.
- Choose a preset or click Customize.
- Under Font, pick a font. Cells without manual formatting, and new cells you type in, use this font.
- Click Done.
Themes control font family, text color, and accent colors, but not font size.
Start New Spreadsheets with Your Preferred Size
- Make a “starter” file: create a blank spreadsheet, select all cells, set your preferred size and font, then use File > Make a copy whenever you need a new sheet.
- Use a template (Google Workspace): business and school accounts can submit a formatted file to the organization’s template gallery from the Sheets home screen.
- Zoom instead: if the text is just hard to read, use the Zoom dropdown (for example, 125%) to enlarge everything on screen without changing the file.
Change Font Size on Mobile
- Open the sheet in the Google Sheets app and tap the top-left corner of the grid to select all cells.
- Tap the A (format) icon, choose Text, and adjust the size.
If Some Cells Keep the Old Size
- New rows still use size 10: rows added below your formatted range may not inherit formatting. Select entire columns (click the column letters) before setting the size.
- Some cells didn’t change: conditional formatting or pasted formatting may override it. Select the range and use Format > Clear formatting (Ctrl + \), then reapply.
- Charts and headers: chart text sizes are set in the chart editor’s Customize tab.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.