10

I often find myself changing text colors to the same color for five minutes at a time which is really unnecessarily mouse-intensive.

| improve this question | | | | |
  • I'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) – LogicDaemon Jan 30 '19 at 17:40
7

Here are the steps:

  1. Press Alt + /
  2. Type the color (eg. blue, red etc)
  3. Hit Enter

Alt + / is like a command palette for all available commands. It's in Help menu.

| improve this answer | | | | |
5
+50

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

    0

  • 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
| improve this answer | | | | |
  • Based 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 – Ananth Apr 2 at 22:05
3

If the last action that you made was to apply the color then use Redo Ctrl + y

| improve this answer | | | | |
0
  1. Copy the cell that has the formatting that you need (Ctrl+C)
  2. Paste format only on top of the cell(s) that you want to be formatted the same way (Ctrl+Alt+V)
| improve this answer | | | | |
-2

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

| improve this answer | | | | |
  • The related thread is very old. The initial post was posted almost 10 years ago and was locked on 2010. – Rubén Feb 2 '19 at 17:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.