7 votes

How can I get code syntax highlighting in Google Docs?

Google Docs launched "Code blocks" on December 14, 2022. It is available to some accounts (depending on the pricing plan). It is not available to users with personal Google Accounts. To ...
Liam's user avatar
  • 1,606
5 votes

How to replace dumb quotes with smart quotes in Google Docs

In Find and Replace, check the box for "Match using regular expressions." To find all the starting quotes: Find (?<=\s|^)\" and replace all with “ (This means "a straight ...
linesarefuzzy's user avatar
2 votes

How to remove insignificant decimal point in Google Spreadsheets?

I know this won't resolve anything for most people, but for me the answer was to format the number as text in Excel before I copied it into Google sheets. Again, probably not useful, but for those of ...
silverbow25's user avatar
2 votes

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

Seems like, as of now (October 2023), Capitals, mentioned in a previous answer, is pretty broken. Unclear if it was providing a caricature or not. But… without writing an add-on, one approach is to ...
Seth Battis's user avatar
2 votes

System of equations in draw.io

Try something like this: \begin{aligned}\tau_v \dot v &= f(\textbf v(t), \textbf w(t)) \\ \tau_w \dot w &= g(\textbf v(t), \textbf w(t))\end{aligned} Note that there's no " ` " ...
arash's user avatar
  • 36
2 votes

How do I make the weight column in my medical log sheet get updated with the most recent weigh-in?

Use reduce() and filter(), like this: =reduce( "", filter('Weight Log'!B$2:Z, 'Weight Log'!A$2:A = A2), lambda( result, current, if( len(current), current, result ) ) )
doubleunary's user avatar
  • 13.2k
1 vote

Automatically append text in cell to URL in Google Sheets

You can't format a cell as a hyperlink, you must either edit the cell or use a formula in another cell to create the hyperlink. Automatic Hyperlink Sheets automatically converts most valid URL formats ...
Blindspots's user avatar
  • 3,380
1 vote

Showing Inline Section Headers in Document Outline

Assign the header to the full text first, THEN manually change the font size, weight, color, etc. of the subsequent body text. The body text will still be assigned to whatever header you assigned it ...
Juno Sprite 007's user avatar
1 vote

Google Sheets auto move to next cell

Having the opposite problem in SHEETS -- every time i type in a cell to edit a formula, when i hit ENTER it automatically goes into EDIT mode on the cell below it... and it is driving me insane! How ...
Joseph's user avatar
  • 11

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