Google Sheets – Limited Font Options Issue

google sheets

Reading around various sites online it seems like you can use any number of Google's web fonts on their Spreadsheets web app, however I only have 6 listed:

screen shot

I've noticed some people have had the option to add more fonts suddenly appear when they change their language to English, but mine is already set to that (UK) and after changing it to English (US) I still don't get the option for more fonts.

Any ideas why this could be please? I'm using the 'new' spreadsheets too.

Best Answer

From what I can see, only Documents and Presentations have the capability for adding more fonts. Spreadsheets seems to be limited (at least for now) to the six listed. (I see several threads on the Google Product forums complaining about this.)

One thing that seems to have worked for some people is to upload a spreadsheet in a different format (e.g., Microsoft Excel) with the desired font and convert it to a Google Spreadsheet. From what they report the font is retained. How useful that would be for new information added to the spreadsheet remains to be seen.

Related Solutions

Google Sheets – How to Let Users Only Change Their Own Data

It's not possible using just Google Docs. If you've written some sort of program that just uses Google Docs as a storage mechanism, then you can do anything you want. For example, you could add a column that records the name of the person who created each row. When someone tries to edit a row, verify that they are the person listed as the row creator before accepting the edit.

Google-sheets – Google Spreadsheets sum only shown rows

I'm not sure if you necessarily require a Google Apps Script solution; the tags you have used suggest that a spreadsheet formula might be adequate. If this is the case, then it is definitely possible to achieve this using SUBTOTAL.

For example:

=SUBTOTAL(109,A:A)

will sum all cells in column A that are not hidden. 109 is the function_code which consists of 9 for SUM, prepended with 10 so hidden values will be skipped.

Your question requests that the sum should be "ignoring rows that are not hidden", which, I believe, is equivalent to "sum the hidden rows". This may be achieved using:

=SUM(A:A)-SUBTOTAL(109,A:A)

Best Answer

Related Solutions

Google Sheets – How to Let Users Only Change Their Own Data

Google-sheets – Google Spreadsheets sum only shown rows

Related Topic