I often find myself changing text colors to the same color for five minutes at a time which is really unnecessarily mouse-intensive.
-
1I'd rather use autoformat and change a value of some cell (autoformat can apply to a cell based on other cell value, use "formula" method)– LogicDaemonJan 30, 2019 at 17:40
-
@LogicDaemon if you think this is a valuable way to do this, please write up a fully functional answer.– pixelearthMar 28 at 22:29
-
It will not be doing exactly "this". To apply autoformatting, the whole workflow will have to change. But without any specifics, I cannot advise any further, this is why it's a comment, not an answer.– LogicDaemonApr 1 at 21:54
5 Answers
Here are the steps:
- Press Alt + /
- Type the color (eg. blue, red etc)
- Hit Enter
Alt + / is like a command palette for all available commands. It's in Help
menu.
-
For changing a color to "dark green 3", that's still quite a lot of keys to press. Mar 28 at 19:32
The answer is no for:
shortcut key for changing text color to the last color?
but you can always make one for color change:
first you will need to click on the toolbar/ribbon to escape the cell
now use this combo:
10x +
15x +
3x + select color
now you can use something like AHK to save this combo (including that initial click) under one key. for example:
- red color under F7 key:
click + tab (10x) + right arrow (15x) + down arrow (4x) + right arrow (1x) + enter
- reset (black) color under F8 key:
click + tab (10x) + right arrow (15x) + down arrow (1x) + enter
- red color under F7 key:
-
1Based on SM Adnan's answer, I've been using the following script in AHK: F7:: Send, {alt down} Send, {/ down} Send, {alt up} Send, {/ up} Sleep 100 Send, red Send, {Down} Send, {Down} Send, {Enter} return– AnanthApr 2, 2020 at 22:05
-
Nowadays you need 13×tab + 17×→. Might depend on your system and google account features, though. Mar 28 at 19:37
- Copy the cell that has the formatting that you need (Ctrl+C)
- Paste format only on top of the cell(s) that you want to be formatted the same way (Ctrl+Alt+V)
No there is not. But you can try following topic? maybe it will be a solution for you, to override some keys on new ones.
https://productforums.google.com/forum/?hl=en#!category-topic/docs/docs-community/lOia0JT4dX4
-
The related thread is very old. The initial post was posted almost 10 years ago and was locked on 2010.– Rubén ♦Feb 2, 2019 at 17:05