3

How can I apply a monospace font to a Google Spreadsheet cell or column? This capability is easy in Excel, Gnumeric, Libreoffice or other desktop spreadsheeets. As of this writing, there's no font setting menu for cells in Google Sheets, and nothing on any context menu.

Why? I've got a series of part numbers to line up. These line up poorly in a regular font:

  • S34ML04G100BHI000
  • W34ML08G200IHI000

And nicely in a fixed width font:

S34ML04G100BHI000
W34ML08G200IHI000

For a similar question about vertical aligment of numbers see How do I decimal-align numbers in Google Sheets

5

There's a font selector right there in the default toolbar. Simply select your cell(s) (or a whole row or column) and then choose your font. "Courier New" and "Consolas" are both monospace fonts (I prefer the latter).

Font selector

  • The hell it doesn't. – ale Mar 26 at 19:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.