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

  • 1
    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) Jan 30, 2019 at 17:40
  • @LogicDaemon if you think this is a valuable way to do this, please write up a fully functional answer.
    – pixelearth
    Mar 28, 2023 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. Apr 1, 2023 at 21:54

5 Answers 5


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


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.

  • For changing a color to "dark green 3", that's still quite a lot of keys to press. Mar 28, 2023 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
  • 1
    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, 2020 at 22:05
  • Nowadays you need 13×tab + 17×→. Might depend on your system and google account features, though. Mar 28, 2023 at 19:37
  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)

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.


  • The related thread is very old. The initial post was posted almost 10 years ago and was locked on 2010. Feb 2, 2019 at 17:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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