4

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

6

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

| improve this answer | |
  • The hell it doesn't. – ale Mar 26 '19 at 19:21
1

There are several more options. They are detailed here: Google's Monospaced Fonts. Hopefully, Google will keep this link updated.

enter image description here

| improve this answer | |
  • 1
    Instead of searching by the string "mono", click on "Show: All fonts" and select "Show: Monospace" – Denilson Sá Maia May 6 at 15:53

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.