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

  • 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

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.


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
  • 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 '20 at 22:05

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

  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. – 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.