Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.
177 votes

How can I get code syntax highlighting in Google Docs?

With the new Add-Ons for Google Drive, you can get code highlighting with the Code Blocks add-on. After installing the add-on, you can access it by selecting the code you want to format, go to _Add-...
user avatar
59 votes

How to insert source code in Google Docs?

With the new Add-Ons for Google Drive, you can get code highlighting with the Code Pretty add-on. After installing it, you can access the add-on by clicking Add-ons → Code Pretty, → Format Selection: ...
user avatar
57 votes

How do I add new styles to Google docs?

A lot of the solutions don't work inline. This is a cleaned-up solution offered by @AlekseyBykov using Google App Scripts to add a custom menu action: Create a new script (Tools > Script Editor) ...
user avatar
  • 701
56 votes
Accepted

How NOT to bold text in WhatsApp & still use ** around text?

You could send it as code using three back-ticks, similar to formatting code here on StackExchange: *word* = word ```*word*``` = *word* (Note: it will use a monospace font).
user avatar
  • 676
25 votes

How can I get code syntax highlighting in Google Docs?

You can add-on Code Block for Google Docs. 1*- Google Docs --> Add-ons Tab --> 2*- Get Add-ons ... --> Search For: 'Code Blocks' 3*- Then you go to Add-ons --> Code Block --> Start 4*- Select Theme(...
user avatar
  • 351
24 votes

How to set a Google Docs Spreadsheet cell format to bare text?

Guide to Adding Custom Number Formats Click on Format Go to Number > More Formats > Custom number formats Paste custom number format (see below) Click Apply . . Different Custom Number Formats ...
user avatar
23 votes

Always a blank line above where I insert a table?

You can reduce the gap at the top of a table by placing the cursor above the table, and reducing the font size. I can't seem to reduce it below 6 points, and even this required me to type the number ...
user avatar
  • 231
18 votes
Accepted

How to create a checkbox column, that if selected will create a strike-through across the entire row in Google Sheets?

Conditional formatting: If checkbox ticked in cell A1, change color/strikethrough of cells from B1-F1. Insert a checkbox from "Insert" tab to A1. Select the cells (B1-F1) that needs to be of ...
user avatar
16 votes

Always a blank line above where I insert a table?

Right now you can fully hide the line with font size 1 and custom line spacing .06, I visually verified that saving as PDF shows no whitespace at the top. Also, in regards to not being able to ...
user avatar
  • 261
16 votes

How do I add new styles to Google docs?

The gratis Google Docs extension Paragraph Styles+ allows to create custom paragraph styles (plus decimal system outline numbering for headings and a table of contents with page numbering). I just ...
user avatar
  • 1,068
15 votes

IMPORTRANGE with preserved formatting

May be an old question but its still being looked up - so here is the workaround: Importrange as we all know will only import raw un formatted data into a new googlesheet. As a workaround to avoid ...
user avatar
  • 325
14 votes

How do I add new styles to Google docs?

The workaround I've come to rely on is the Copy/Paste Format feature shortcut. As the format "clipboard" is separate from the text clipboard, it is preserved for as long as you have the document open. ...
user avatar
  • 293
14 votes

How can I format text as code in Inbox by Gmail?

You can install the Markdown Here extension for Chrome and write the code in markdown format in the email compose window. You can either write the code with a four-space indent: this is some ...
user avatar
  • 604
12 votes

How to change the default style of text links in Google Docs

It does not appear to be possible to update the default style for links in your Google doc. This is because Google docs does not treat links as styles. This is understandable, as a link might be ...
user avatar
12 votes

How NOT to bold text in WhatsApp & still use ** around text?

Excerpt from the official WhatsApp FAQ: Note: There is no option to disable this feature. See https://www.whatsapp.com/faq/en/general/26000002
user avatar
  • 221
11 votes

Using the Google Documents equation editor, how can I enter the binomial coefficient?

It is true that the notation for the binomial coefficient isn't included in the menu, but you can still use it by using the automatic shortcuts. When in the equation editor, type \choose then press ...
user avatar
11 votes
Accepted

Stop Google Sheets formatting text as URL

I couldn't find an absolute setting to just disable this function. However, you can disable the function from continuing to create links or start creating links in a new document simply by selecting ...
user avatar
  • 128
10 votes

Google Docs is altering my formatting, how can I avoid this?

I realize this question is nearly 5-years-old, but since the problem still persists in Google Docs, I'll share the solution that works for me. Simply, use the “print” feature within the Chrome browser....
user avatar
  • 101
10 votes

How can I get code syntax highlighting in Google Docs?

Just to be clear for rookies like me, No, there is no code highlighting natively in Google Docs. There are add ons that can do code highlighting. Code Pretty is mentioned above and has adequate ...
user avatar
10 votes
Accepted

How to change the default style of text links in Google Docs

I just published a free add-on for precisely this task. It's called Link Style, and is available here.
user avatar
  • 391
10 votes
Accepted

Adding a header and footer to a Google Spreadsheet

Headers and Footers show up in the Print dialog box. Click print and look for "Headers & footers" toward the bottom of the right panel. You can select page numbers, Workbook title, Sheet name and ...
user avatar
10 votes
Accepted

Is it possible to format small-caps in Google Documents?

Yes you can, but I don't know how to do it, at least not directly. However, it is possible. If you copy in text that's already small caps (e.g. from wikipedia), Docs will preserve the setting. You ...
user avatar
  • 216
9 votes

How can I get code syntax highlighting in Google Docs?

I've found out that copying pastes from Pastebin works perfectly, and as an added bonus it adds line numbers that are recognized by Google Docs as numbered list. You go to Pastebin, create an ...
user avatar
  • 191
9 votes
Accepted

Date and time format

I use this formula to convert the date time values IFTTT spits out to a useful format: =VALUE(SUBSTITUTE(A1, " at ", " ")) Where A1 is the cell containing the date string This gives you a decimal ...
user avatar
  • 206
9 votes

Is it possible to format small-caps in Google Documents?

Working on a Google doc, there is a header titled "Add-ons" - click on that. Then select "Get Add-ons". I did a search on small cap and 'Capitals' came up. Download the program. Highlight the text ...
user avatar
9 votes
Accepted

How do I transpose data in a Google Sheets and keep the formatting?

To preserve the data and the formatting: go to Edit choose Paste special choose Paste transpose (A1:C27)
user avatar
7 votes

How can I align a table so that text floats around it in Google Docs?

This isn't possible, however there is a work around - use a drawing. Insert -> Drawing In the drawing, create a text box or shape (if you would like the box to have a background), add the text. ...
user avatar
  • 170
6 votes

How do I change date and time formats in Trello?

Change your language settings to English (UK) in your Atlassian account and you will get 24-hour time settings.
user avatar
  • 71
6 votes

Can I add a line break in my Twitter bio?

Use   to pad out your bio to force it to a new line. It takes up more space than   so if you need a lot of space you can use it instead.
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible