5

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

migrated from superuser.com Dec 7 '17 at 8:47

This question came from our site for computer enthusiasts and power users.

  • 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 at 17:40
3
+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
1

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

1

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.

-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

  • The related thread is very old. The initial post was posted almost 10 years ago and was locked on 2010. – Rubén Feb 2 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.