

- KEYBOARD SHORTCUTS FOR GOOGLE DOCS HOW TO
- KEYBOARD SHORTCUTS FOR GOOGLE DOCS UPDATE
- KEYBOARD SHORTCUTS FOR GOOGLE DOCS FULL
check that the edited cell is in the trigger column get the edited value for the cell as a string Var colorRow = sheet.getRange(thisRow,thisCol,1,Cols) set a range variable for the entire row get the cell you edited and the associated column and row number Note: Some shortcuts might not work for all languages or keyboards.
KEYBOARD SHORTCUTS FOR GOOGLE DOCS UPDATE
function to update row color using entered text in a specified "trigger" column Use keyboard shortcuts in Google Docs to navigate, format, and edit. *you will need to add an onEdit trigger to your project You can use this to do anything that can be done on the sheet via scripting such as change values, set font weight, copy data, or even run other functions after checking the trigger text input.
KEYBOARD SHORTCUTS FOR GOOGLE DOCS HOW TO
I've provided an example below for how to change row color based on trigger text in a designated "trigger" column. If you need something to process more quickly you may have to look for an alternate approach.
KEYBOARD SHORTCUTS FOR GOOGLE DOCS FULL
The biggest downside to this approach is that it takes (at least for me) approximately 7 full seconds for the onEdit trigger to catch the change and perform the update. You can then set an onEdit event trigger in the project's triggers under "Resources" in the script editor for your hotkey function. Keyboard Shortcut You can use a universal shortcut to insert the em dash not just on Google Docs, but on other word processing applications as well.

Holding Ctrl + Alt + Shift, press E then OĪfter selecting one section of text, Ctrl + Alt + Shift + Left/right arrow. Holding Ctrl + Alt + Shift, press E then I (available in documents in non-Latin languages)Įxtend selection to the beginning of the lineĮxtend selection to the beginning of the documentĮxtend selection to the end of the document (present when screen reader support is enabled) Use keyboard shortcuts on selected comments Every change is automatically saved in Drive
