Master Excel with our tips, tricks & tools!
Subscribe to our Free Email Newsletter

Keyboard Shortcuts to Change Font & Fill Color or Cell Style

This post will show you how to create keyboard shortcuts to change font & fill colors and apply cell formatting to your worksheet.   If you spend time clicking buttons on the ribbon to style your worksheet, these shortcuts will really increase your productivity!

Formatting Shortcuts Excel Userform 2.4

_

Do you spend time doing any of these tasks?

Common Formatting Mouse Actions - Excel

_

Wishing there was a Faster Way…

The Formatting Shortcuts Add-in will allow you to create keyboard shortcuts to perform these same actions in a fraction of the time.

Formatting Shortcuts Add-in Setup Demo

_

Formatting Shortcuts Add-in

If you use keyboard shortcuts, you’ve probably found that there are NO built-in keyboard shortcuts to apply font and fill colors or cell styles.

So I developed this simple add-in that allows you to create customized keyboard shortcuts to apply font and fill colors, or cells styles to the selected cell(s).  It also allows you to retain the full undo history after pressing a keyboard shortcut.

This add-in will be a huge time saver for anyone that does financial modeling or data entry.  The video below contains many examples on how the add-in can be used to make you more efficient with keyboard shortcuts.  If you do a lot of financial modeling in Excel then you will really appreciate the ability to create keyboard shortcuts to apply cell styles.  Styles can include any cell formatting properties such as number formatting, borders, protection, alignment, etc.  You can use the built-in styles or customize them for each workbook/model.

Video

_

Features

  1. Easy to Use – The shortcut keys and cell formatting can be changed with the click of a few buttons.
  2. Unlimited Options - Any combination of formatting properties can be applied with a keyboard shortcut.  This includes custom styles and all formatting options.
  3. Full Undo History - The undo history is retained so you can undo any changes made by the keyboard shortcuts.  If you have recorded or written your own formatting macros, you know that undo history is typically lost when you run a macro.  This add-in works around that to retain the undo history.  More details about undo on the help page.
  4. Save Time – Improve your efficiency and style worksheets in a fraction of the time it would take with mouse actions.
  5. Consistency – The add-in saves your styles so you can start using the keyboard shortcuts when you open a new workbook.  No setup needed (even for custom styles).  Using the same styles throughout your models will make it easier for users to read and understand.  Read more about styles on the help page.

_

Formatting Types

  1. Font Color - Applies the font color to the selected cell(s).
  2. Fill Color - Applies the fill color (cell shading or background) to the selected cell(s).
  3. Font+Fill Color - Applies both the font and fill color to the selected cell(s).
  4. Cell Styles (full version only) - Applies the cell style to the selected cell(s).  Formatting for cell styles include:
    - font color
    - fill color
    - text formatting (bold, italics, underline, etc.)
    - border properties (color, weight, line style, etc.)
    - alignment (left, right, centered, etc.)
    - cell protection
    - The image below shows the Cell Styles menu.  Cell styles can be added and modified (customized) in Excel.

    Excel Cells Styles Menu

    Click to Enlarge

_

Versions

The add-in is available in two versions.  Both versions are compatible with Excel 2007, 2010, and 2013.

Lite Version

The lite version is free to download below and allows you to create up to three keyboard shortcuts for font color, fill color (cell background), or both font & fill color.  It has a single undo feature, which allows you to undo your keyboard shortcut action one time.

Formatting Shortcuts Lite Ribbon Button Userform

_

Full Version

The full version is $4.99 US and allows you to create  12 keyboard shortcuts.  It includes the addition of the cell styles format type to create shortcuts for all cell properties (number formatting, borders, font, alignment, etc.)  It also includes the ability to preserve the full undo history.  This means you can undo any of the formatting you applied with the keyboard shortcuts using the Undo button or Ctrl+Z.  The Cell Styles and Undo History are two great features that I think you will find really useful.

Formatting Shortcuts Excel Userform 2.4

_

The full version also includes a Key List feature.  Clicking the Key List button will create a new workbook with a list of all your shortcut keys.  You can print this list and use it as a reference to learn and memorize your shortcuts.

Formatting Shortcuts Key List

The full version includes a full money-back guarantee.  If you are not satisfied, you may get a full refund within 90 days of purchase.

Both versions include free upgrades and support.

Product Comparison

Formatting Shortcuts Product Comparison 2.4

Download

Lite Version - FREE
Full Version - $4.99 US

Add to Cart   View Cart

PayPal Acceptance Mark

After purchase you will be redirected to a secure download page.  You will also receive an email with a link to download the zip file.

Compatible with: Excel 2007, 2010, 2013

All purchases are backed by our 100% Money-back Guarantee.

What’s in the Zip?

The zip file contains: the add-in file, installation guide, and user guide.

Formatting Shortcuts Zip File Contents

Online Help Pages

How to Install an Excel Add-in Guide

Formatting Shortcuts Add-in Help Page

What do you think?

I want you to love this add-in, so please leave a comment on how it works for you or how it can be improved.

If you enjoyed this article, subscribe to our free newsletter!

Thank you, your sign-up request was successful! Please check your e-mail inbox.
Given email address is already subscribed, thank you!
Please provide a valid email address.
Oops. Something went wrong. Please try again later.

36 Responses to Keyboard Shortcuts to Change Font & Fill Color or Cell Style

  1. Mohamma Enamu Huq says:

    Just Awesome!

  2. don hahn says:

    Good product, couple of questions:

    1. Is there option to add in more than 3 format styles? I’m liking it because I can quickly format without having to use the mouse to hit my macro buttons on the ribbon and it retains the undo.

    2. One format I use is fill cells with blue, make text white and then center across columns. I’m guessing that I can’t use the add in if I have variable range of columns that I’m going to center across?

    • Jon says:

      Hi Don,

      I’m glad you’re enjoying the add-in. Currently you can only save 3 keyboard shortcuts at one time. This could be expanded to 5.

      Yes, you can create a shortcut for the center across alignment by creating a cell style with the formatting properties. To apply it to a range, simply select the range and then press the keyboard shortcut. Your selected cells will be formatted with the center across alignment.

      By the way, center across is a much better alternative to the more popular merge and center alignment. Merging cells can cause issues when inserting columns or copying cells. It typically requires a lot of extra work to constantly merge and unmerge the cells. It can also cause issues when working with VBA. I much prefer the center across alignment over merge and center.

      Thanks again,
      Jon

  3. carlo says:

    On the full version it seems I cannot change the type of font/style I want to save in the shortcut??

    Can you please assist me here?

    Regards

    • Jon says:

      Hi Carlo,

      I would be happy to help. To change the font or style for the shortcut, you will first need to format a cell with the font type or style you want to use, then set that by clicking the Cell/Format box in the Formatting Shortcuts menu. You will also need to change the Format Type to Cell Style. Here are some step-by-step instructions.

      1. Format a cell in your worksheet with the formatting you want to use with a keyboard shortcut.
      2. Click the Formatting Shortcuts button in the Add-Ins tab of the ribbon.
      3. In this example we will setup shortcut key #1. The shortcut key should be already setup as Ctrl+Shift+A.
      4. Select “Cell Style” from the Format Type drop-down box.
      5. Click the box to the right of the Format Type drop-down. You will be prompted to select the formatted cell. This is the cell you formatted in step 1.
      6. Selected the formatted cell and click OK. Then click Save & Close in the Formatting Shortcuts window.
      7. Your keyboard shortcut should now be ready to use. Select an un-formatted cell in your workbook and press Ctrl+Shift+A to format it.

      Please let me know if this helps answer your question.

      Thanks,
      Jon

  4. Madhur Dutta says:

    Nice! Its helping me a lot. Thanks :)

  5. Jake says:

    Please add the option to save more than 3 formats. For heavy excel users, 10+ format options seems about right. If you’re able to make the change, we have a large office that would probably be interested in the add-in.

    • Jon says:

      Thanks for the suggestion Jake. The next version will have an option to save more formats. I don’t have a release date for this yet, but I will let you know when it is available.

      Thanks,
      Jon

    • Jon says:

      Hi Jake,

      The add-in has been updated to include 12 shortcut keys. It also contains a Key List button to create a printable guide of your shortcuts to help you memorize them.

      I will be sending out an email next week with the details, but the add-in is available for download now.

      Please let me know if you have any questions.

  6. Don Hahn says:

    the update with 12 shortcuts is awesome!! One thing i would ask is maybe allow the user to assign the letter. I was using “D” for one format but it was a predefined format. I suppose I could have gone down to “B” and assigned it my own formatting? Keep up the great work.

    • Jon says:

      Thanks Don! You can assign the letter of each shortcut in the Key field text boxes. These keys are not locked, and you can change it to any letter character. Number characters already have built-in keyboard shortcuts for Ctrl+Shift, so the numbers can not be used.

      You can also delete the letter in the Key field text box if you want to temporarily disable the shortcut key.

      I am not sure I fully understand your question, so please let me know if this answers it. Also let me know if you think of a way that any of the processes can be easier or more intuitive.

      Thanks again!

      • Don Hahn says:

        Got it. I didn’t realize that the shortcut letters could simply be changed and saved. Answers my question, deleting the shortcut key letter will temporarily disable the shortcuty key. Again, this is a very handy tool where I don’t have to memorize the shortcut keystrokes or move the mouse to get to and change ribbons.

        • Jon says:

          I am glad you asked, as others will probably have the same question and hopefully this will help. The new Key List button will also help you memorize your shortcut keys. Thanks again, I am happy that you find it useful.

  7. Don Hahn says:

    The Key List is great. I’m sure once I’ve used them enough I’ll have them memorized but I already have 8 formats that I regularly use. The Undo feature is amazing. I have macros and icons on ribbon to do the same, but I’ve always had the issue of not being able to use the undo feature. This is a great product.

  8. RLP says:

    Is there a version that works with excel for mac 11?

  9. Marco says:

    I just tried the lite version and wanted to tell you that it’s awesome. When my needs pile up, I will buy the full version. Thank you very much.

  10. Russell says:

    Hello, I have a problem with Formatting Shortcuts Lite Version: 2.3. Every time i open an excel spreadsheet, it turns my Num Lock key off. This is very frustrating. Can you please assist?

    • Jon says:

      This issue has been resolved in version 2.4 (available for free download above).

      Please let me know if you experience any other issues.

      Thanks!
      Jon

  11. Ramesh says:

    Hello! I’m getting the following error after formatting my windows 7.

    Microsoft excel cannot access the file ‘c:\users…..’. There are several possible reasons.
    . the file name or path does not exist.
    . the file is being used by another program.
    . the workbook u r trying to save has the same name as a currently open workbook.

  12. Sri says:

    Thank you for awesome Add in

  13. Dan says:

    I installed on excel 2010 and upon opening the add in I get the following error message: “Run-time error ’91′: Object variable or With block variable not set”

    I can see the add-in interface behind this dialogue box, but obviously can’t do anything with it because the dialog box only allows me to close the add-in program.

    Any thoughts?

    • Jon says:

      Hi Dan,

      Typically that will happen if you do not have a workbook open. Open any workbook or create a new blank workbook before pressing the add-in button on the ribbon. Let me know if that helps resolve the issue.

      Thanks!
      Jon

  14. Ste M says:

    This Add-In fixes just the issue I wanted solved! Works perfectly.

    Thank you very much and I hope you make some nice pocket money from your good work!

  15. […] Looks like the Free version will work for you Keyboard Shortcuts to Change Font & Fill Color or Cell Style | Excel Campus […]

  16. Anthony says:

    Hello,

    I am trying to install this on my office 365 excel x64 and it is not allowing me to even pick out the lite version from the file. Do I need special installation instructions???

    • Jon says:

      Hi Anthony,

      My apologies for not getting back to you sooner. I just saw your comment. Were you able to get this to work? Can you send me a screenshot with the error message, or the menu where it is not allowing you pick out the add-in file? jon@excelcampus.com

      Thanks!

Please leave a comment

Subscribe without commenting