This simple add-in allows you to create keyboard shortcuts for font & fill colors, and cell styles (number formatting, borders, alignment, etc.). Full undo history is preserved. This add-in will help make you fast and efficient at styling and modeling your worksheet. Free version is available for download.

Excel Font Fill Color Keyboard Shortcut KeysHave you been searching Google to find keyboard shortcuts to apply a font or fill color to a cell?

Well, you can stop your search… 🙂

I have spent a lot of time researching this topic as well.  This page will hopefully help you with some answers and solutions to this question.

No “Good” Built-in Shortcuts

Unfortunately, there are no built-in keyboard shortcuts in Excel for font or fill colors.  There are a few “workaround” methods that I explain in another blog post, 5 Excel Keyboard Shortcuts for Font & Fill Colors.  But these built-in methods are either slow, or do not provide a direct solution.

Keyboard Shortcuts for Font & Fill Colors

So I developed an add-in that allows you to create keyboard shortcuts to change the font & fill colors.  This add-in also lets you create keyboard shortcuts to apply other cell formatting properties like number formatting, borders, font size, protection alignment, etc.

Formatting Shortcuts Lite Excel Userform

The add-in is named “Formatting Shortcuts” and there is a free version available for download.

Click Here to Jump to Download Section

Time Saving Shortcuts

The Formatting Shortcuts add-in will save you a lot of time if you are currently using the mouse to format cells.  Again, this includes any type of formatting and is not just limited to font and fill colors.

The image below shows some common tasks that we all do in Excel to format cells.  It includes the buttons on the ribbon that we press over and over again to apply formatting._

Common Formatting Mouse Actions - Excel

The Formatting Shortcuts add-in will allow you to create keyboard shortcuts for any of these actions.

The keyboard shortcuts are quick and easy to press in one step.  This will save you a ton of time over having to navigate to the ribbon (toolbar) with the mouse.

Video Demo

Here is a video that explains how the add-in works.  You will see that it is fast to setup and easy to press the shortcut keys.

Click Here to Jump to Download Section

In the video above I demonstrate a few different ways to apply different formatting types with the custom keyboard shortcuts.

Keyboard Shortcuts Are EASY to Press

The keyboard shortcuts you create all start with Ctrl+Shift.  Then you get to choose the letter at the end of the key combination.

For example, in the screenshot below I have setup the shortcut Ctrl+Shift+S to apply the yellow fill color to a cell or range.

Formatting Shortcuts Lite Excel Userform

The shortcut Ctrl+Shift+S is very easy to press because the keys are close together and can all be pressed at one time with your left hand.

Keyboard Shortcut Diagram Ctrl+Shift+S Yellow Fill

This beats alternative methods of having to press Alt+H+H, then pressing the arrow keys to find the color on the palette.  That method is slow and difficult to perform.

But the Ctrl+Shift+{letter} shortcuts you use with the Formatting Shortcuts add-in are easy and efficient.  They will save you a lot of time.

Click Here to Jump to Download Section

Undo Your Mistakes

The Formatting Shortcuts add-in also allows you to undo your mistakes.  If you have ever recorded your own macro and assigned a shortcut key to it, you know that you lose the undo history when you press the shortcut key to run the macro.

This is not the case with the add-in.  The full version of the Formatting Shortcuts add-in allows you to retain the full Undo History in Excel.  So you can use Ctrl+Z or the Undo button if you accidentally press one of the shortcut keys.

The screencast below shows an example of this.  In this video I setup a shortcut key for a cell style that contains number formatting, borders, font, and fill colors.  I then use the keyboard shortcut Ctrl+Shift+A to apply the formatting to a few cells. Finally, I undo my actions using the Undo button.

 

Formatting Shortcuts Add-in Setup Demo

Click Here to Jump to Download Section

Features

Here are a few additional features of the add-in:

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

Click Here to Jump to Download Section

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

    Click Here to Jump to Download Section

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

 

Click Here to Jump to Download Section

Full Version

The full version is $14.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 Comparisons 2.4

Download

Lite Version – FREE
Full Version – $14.99 US

Add to Cart

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, 2016 for Windows Only

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.

122 comments

Your email address will not be published. Required fields are marked *

  • And once again we turn to others that were once in need because MS never cares about solving trivial issues that common paying users raise.

    Excellent addin, great functionality, does what’s written on the label.

  • Great, Excellent, and more, You are awesome.
    How big, and difficult is to write a Add-ins Code, because definitely microsoft do nothing new. we margings for the IDE on vba, we need generate next when you write for and so on.
    Thank you.

  • A great add-in, I used at all the time, until it mysteriously stopped working. I would set in up, save the custom changes and the next time I opened Excel..they’d be gone. Again, too bad, as it really is the only game in town for this type of functionality.

  • I love reading through an article that can make men and women think. Also, many thanks for permitting me t? comment!.

  • Unable to use this Addin. Following error is occurring. :

    Run time Error ‘1004’:
    Method ‘OnKey’ of object ‘_Application’failed

    Please Help!

  • Dear Mr Jon

    thank you first for your efforts

    i downloaded the zip file “Formatting Shortcuts Lite Add-in”

    but it only contains :

    10 Excel Pro Tips eBook – Jon Acampora.pdf

    10 Excel Pro Tips Workbook.xlsx

    the file with extension .xlam is not included with the zip file

    any help will be appreciated .
    thank you

  • Hi Jon,

    Thanks a lot for your addon, helps a lot. But I would like to ask you for another solution, if you know it.

    There is a possibility to make a custom ribbon in Word and Excel which is absolutely beautiful. But is there a way to add two buttons for changing font color:
    * one – black
    * second – blue

    This simple thing would hugely improve processes in my company. If you know how to add two font color buttons with different colors, I am ready to pay $10 or more, let us say.

    Thanks in advance!
    Looking forward to hear good news.

    Mike

    • A simple way that I’ve used to overcome this is to program two simple macros (Black and Blue) and add them to the ribbon. Just paste these two macros to your personal.xlsb file, add them to the ribbon and change the icons and you should be all set.

      Sub Blue()

      ‘ Macro4 Macro


      With Selection.Interior
      .Pattern = xlSolid
      .PatternColorIndex = xlAutomatic
      .Color = 15773696
      .TintAndShade = 0
      .PatternTintAndShade = 0
      End With
      End Sub
      Sub Black()

      ‘ Black Macro


      With Selection.Interior
      .Pattern = xlSolid
      .PatternColorIndex = xlAutomatic
      .ThemeColor = xlThemeColorLight1
      .TintAndShade = 0
      .PatternTintAndShade = 0
      End With
      End Sub

      You can send the $10 to my paypal account. – just kidding

  • Jon,

    Just downloaded all the addins (love em) very helpful… one question I have is that on all of them they are installed under the XL Campus Ribbon group and then the Formatting addin installs under a different one… it may seem like a silly question/request but given limited “real estate” on my laptop is there a way to move the formatting one under the XL Campus Ribbon group.?

    • Hi Bill,
      Thank you for purchasing the add-in. Not a silly question at all. I thought I had done that, but looks like I forgot to upload the file to the members area. I just uploaded the new file with the button on the XL Campus tab. You should be able to download and install it.

      To install the update:
      1. Close Excel completely.
      2. Download and unzip the new add-in file from the members site.
      3. Find the existing Formatting Shortcuts Add-in file (EC_Formatting_Shortcuts_Full.xlam) that you saved on your computer.
      4. Replace the existing file with the new file.
      5. Open Excel. The Formatting Shortcuts button should appear on the XL Campus tab of the ribbon. The Add-ins tab will not appear unless you have add-ins installed from other developers that use that tab.

      Please let me know if you have any questions. Thanks again!

  • Love this addon! I’m going to purchase the full version. Just want to confirm, you’ll continue to support it as new Excel versions are released. Thanks!

    • Hi James,

      Thank you for your purchase. I really appreciate your support. Yes, I will continue to support it for new versions of Excel for Windows. Please let me know if you have any other questions. Thanks again!

  • Hi Jon,

    I have tried to add the formatting shortcuts add-in, which it did install but when I clicked on it I immediately got an error message that states

    Run-time error ’91’:
    Object variable or With block variable not set

    What did I do wrong?

    Juliet

      • Hi Jon,

        I got it working. Initially I saved it to a shared drive, but when I saved it to my computer hard drive it started working.

        It is usful in my line of work however, I am finding that I use this short cut to color coordinate cells, and then when I send my excel spreadsheet via email to a coworker, she reports that the spreadsheet comes in blank, with no highlighted cells.

        If someone else does not download the short cut then any colors that were established, will they not appear when someone else opens the same document in excel?

        Juliet

        • Hi Juliet,

          The colors should appear in the file for your co-worker. She does NOT have to have the add-in installed.

          The add-in is just creating a shortcut for the manual operation you would do to change a font or fill color.

          The only thing I can think of is that the file is not being saved before you send it. You can send me the file if you are still having issues. jon@excelcampus.com

  • Hi Mr. Jon,

    I really love this add-in of yours. It makes me super fast when working with Excel. Thank you a lot for that. I really appreciate your work!

    However, the add-in is not working currently. I keep installing the add-in extactly the way you teach us how to install (pretty easy), but the add-in section on the ribbon keeps becoming lost and I cannot use the shortcuts I assigned. I have to install it everytime I open a new Excel workbook to use the add-in. You know, it is really time-consuming as I always open new Excel workbooks. Why do you think that problem occurs? Do you have any solutions for the problem? Thanks in advance:)

    Best Regards

  • Seriously this add-in helped me a lot.. I am a chartered accountancy Student and it is time consuming when I change the color in excel for my audit, to an extend the format painter was helpful. But thanks for developing this.. I wish more colors could be accessible through this add-in
    Thank you.

    • Thanks for the nice feedback Abhijith. I’m happy to hear the add-in is saving you time. The Full version allows you to save up to 12 colors or cell styles with number formats.

  • This doesn’t work for me. When I select a cell to change the cell format, it doesn’t copy the format I selected. It’s a totally different random format.

          • Hi Craig,
            Yes the add-in works for the 2016 version for Windows. Did you install it through the add-ins menu? You might want to try restarting Excel (completely close all instances of Excel and reopen it). Let me know if that helps. Thanks!

          • Hi Jon

            I was mistaken, I’m actually using Office 2013. I installed as per your PDF guide included in the zip. I also tried restarting as a matter of course when I first encountered the error to no avail.

            However, I did find a fix/workaround:-

            1) Select the cell you’re wanting to copy the formatting from
            2) click Fill -> More Colours -> OK
            3) Now Select it with Formatting Shortcuts add-in and it’ll correctly pickup the Fill.

            Thanks for your add-in.

        • Hi Matias,
          I’m not sure what is going on there. The Formatting Shortcuts Add-in does work in Excel 2016. You might want to try completely restarting Excel by closing it down and re-opening it. If that doesn’t work can you send me the file you are working with. jon@excelcampus.com
          Thanks!

  • Hello Jon,

    I have been searching for this functionality for a long time, very excited to find your add-in. I am running Excel 2016, and I have enabled the Add-in. When I use the key combination I defined, I get the following message:”Cannot run the Macro “C\Users…..Formatting_Shortcuts.xlam” The Macro may not be available in this workbook or all macros may be disabled.” I frequently use macros, so I know that they are not disabled. Can you advise any potential solutions?

    Thanks,
    Noah

    • Hi Noah,
      Sorry to hear you are having that issue. You might want to try to completely close Excel, then re-open it. Sometimes that can clear up those issues. Let me know if that helps. Thanks!

  • Is there really no mac version? I would honestly do anything for a mac version for this add-on. Is there anywhere else to find something similar?????? Help me!

    • Hi Alex,
      I don’t have a Mac version. It would probably be possible to create for Excel 2011 for Mac. However, Excel 2016 for Mac is pretty limited with macro and VBA functionality right now. It is almost impossible to develop for and not worth the effort yet. Hopefully that will change in the future. Let me know if you have any other questions. Thanks!

    • Seriously. I just got VERY excited about this as my monthly budget has different font and fill colors for Estimate, Actual and Paid. I literally change font/fill hundreds of times a month and the idea of the time saved with a keyboard shortcut is amazing. I wish I never saw this product…now I know what is possible, but not for me 🙁

      • Hi Steven,
        One workaround is to create a macro in your personal macro workbook and assign a shortcut key to it.

        The macro could look something like the following.

        Sub Fill_Yellow()
        
        Selection.Interior.Color = vbYellow
        
        End Sub

        You would just need to assign a shortcut key to the macro. I did this on the 2011 version for Mac and assigned the shortcut key Cmd+Option+y.

        Now every time that shortcut is pressed, the selected cells are filled yellow. I hope that helps. Let me know if you have any questions. I will write an article about it with more details in the future. Thanks!

        • I have Office 2008 for Mac and it appears that the geniuses at Microsoft eliminated the Personal Macro Workbook feature for this version only. I’ll probably be upgrading soon anyway, so I’ll hold on to this tip, which sounds like a great solution. Thanks!

          • Yeah, unfortunately the Mac version doesn’t get as much love when it comes to macros & VBA. In my opinion, 2011 is the best version for using macros & VBA on the Mac right now. The 2016 version took another step back and the VB Editor is quite limited. Hopefully that changes in the future. Thanks!

          • In general, do you recommend the new Office 360, Office 2016 or Office 2011 versions for Mac? I have two computers that need to be upgraded and I don’t want to pick something that’s going to be problematic.

          • If you plan to use macros or do any type of coding then I would recommend the 2011 version. There are some additional features in 2016 that make it more like the Windows version, but the VB Editor isn’t good for coding and debugging. I don’t use the Mac on a day to day basis, so it’s hard for me to really make a strong recommendation. I have developed VBA projects for the Mac, including my Tab Hound add-in, and 2011 will be the only way to go for stuff like that. I hope that helps.

  • Hey Jon,

    Using your full product for some time on huge spreadsheets. At times, I want to highlight a group of cells in a column that span over 30K rows (Not total, but row numbers range past 30,000). Excel kicks back an error when I try to highlight above 30,000, saying Runtime error ‘6’. Any idea why?

    I am able to highlight an entire column and bold everything with one keystroke, but highlighting seems to not want to do the same.

    • Hi Michael,
      Is the range filtered? If so, there will probably be some limitations if you are trying to apply the formatting to the visible cells only. Let me know if that is not the case. Thanks!

      • Whether filtered or not, I cannot successfully highlight any amount over 35K. that can be if the numbers run seqentialy from 1 to 35,000, or if they are filtered and I highlight two cells, 1 and 35,000.

        What’s puzzling is that I can highlight 100K rows and use the Excel fill tool, which works without issue.

  • You just made my work life so much easier! I have to color-code an Excel worksheet all day long, and this is going to be so much faster. Amazing!

  • Hello, I had installed this add-in on my previous computer. I just got a new computer and had downloaded the add-in again, but this time I am getting an error message (on Save&Close) that is not allowing me to use it. It is a Microsoft Visual Basic error: “Run-time error ‘1004’: Method ‘OnKey’ of object ‘_Application’ failed.

    I also noticed that the 1st macro Key (Ctrl+Shift+A) does not have anything selected in the Key field. I tried putting in “a”, “A”, and some other letter, but still was unable to Save&Close.

    Have you seen this before, and do you have any recommendations on how to resolve this problem? I like this macro and would like to use it again!

    Thank you.

    • Hi Gabrielle,
      My apologies for not responding sooner. I missed your comment. What version of Excel is on your new computer. You might want to try disabling the add-in from the Add-ins menu. Completely close and re-open Excel, then enable it again. Thanks!

  • If i purchase the add on, and then after using it, i changed my laptop, can the add on be transferred to my new laptop? Just wanna be sure that I dont have to purchase duplicates again.

    • Hi JEH,
      Yes, you can use the add-in on up to 3 computers that you own at any one time. So if you get 3 new computers, you can use it on all of them without having to make an additional purchase. Please let me know if you have any other questions. Thanks and have a great day!

  • Yes – excellent tool. The “fill shortcut” feature is saving me a TON of time on a gigantic spreadsheet. This contribution earns you an email “list” at the very least.

    Maybe I’ll upgrade.

  • Hi,
    the undo function is not working.
    Arrow to undo is appear, but when i click on, arrow disappear but filled colour not disapear.
    Lite Version. Excel 2010.

  • Hello Jon,

    I purchased the add-in some time ago and overall I’m very satisfied with my purchase, however I am experiencing an issue with the add-in. Sometimes when I save a file in a directory in windows explorer, it saves a copy of the add-in. In other word it creates a file with the name “EC_Formatting_Shortcuts_Full.xlam” in the same directory as I saved a file in.

    How can I fix this?

    Best regards,
    Frederik

    • Hi Frederik,

      Thank you for letting me know. That happens when multiple instances of Excel are open at the same time. This is something I need to fix with the add-in. You can delete those copies of the add-in file, but I realize this is probably annoying. I will let you know when an updated version is available with the fix.

      Thanks again for your purchase Frederik! I really appreciate it.

      • That was a quick reply!

        Yes that would be great.

        I don’t personally mind it too much, but it confuses my boss and other people working in the same directories, who might tell me to stop using it.

        Thank you Jon.

      • Hello, did this multiple excel instances fix ever get created? Please let me know so i can dl the latest version when avbl.

  • hi – When I apply the shortcuts for color fill, save my Excel doc and then send to my client to review and edit, will he be able to use the same shortcuts without having to download the add-in on his end?
    thanks!

    • Hi Laura,
      Unfortunately it doesn’t work that way. Add-ins are local to your computer, so your client would have to have the add-in installed as well.

      One solution would be to add the macros to a macro enabled workbook. Then the shortcuts would travel with the file. Let me know if this would work for you and I can provide the code. The only real requirement is that your client can use workbooks that contain macros (.xlsm files). Some companies restrict their use.

      Thanks

  • Awesome shortcut. Searched for a Facebook link to LIKE you – don’t see one. Sharing this link on my page. Many friends will appreciate this.

    • Thanks Heather! And thank you so much for letting me know about the Facebook button. I just added some social buttons to the sidebar on the right.

      Is that what you were looking for? Should I add a “like” button instead?

      Here is the link to my facebook page. I’m just getting it started and could use some “likes”. 🙂

      https://www.facebook.com/ExcelCampus

      Thanks again!

  • 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???

    • 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!

  • 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!

  • 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?

    • 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

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

  • 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?

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

        • Wanted to bump this, to let you know there is another mac use that would love this! I found this page searching for ‘excel shortcuts change fill color’.

          • Thanks Brendan! I definitely think this is possible on the Mac and I will try to get a Mac version out soon. I recently developed another add-in for the Mac named Tab Hound. I enjoyed developing for the Mac and it’s something I will do more of in the future. Thanks for letting me know how you found me as well. Have a good one!
            Jon

          • Thanks Brendan! I definitely think this is possible on the Mac and I will try to get a Mac version out soon. I recently developed another add-in for the Mac named Tab Hound. I enjoyed developing for the Mac and it’s something I will do more of in the future. Thanks for letting me know how you found me as well. Have a good one!
            Jon

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

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

    • 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!

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

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

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

    • 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

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

  • 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

    • 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

  • 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?

    • 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

  • […] I've developed a simple add-in that allows you to create custom keyboard shortcuts to apply font and fill colors to the selected cells. It also retains the undo history. Keyboard Shortcuts to Change Font & Fill Color or Cell Style | Excel Campus […]

Search
Generic filters
Exact matches only
Filter by Custom Post Type

JOIN US & LEARN EXCEL

Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
Plus weekly updates to help you learn Excel.

Download the eBook

About Me

Jon Acampora Profile

Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

MVP_Horizontal_BlueOnly