Your web browser may be malfunctioning. Your internet connection may be unreliable. Create custom keyboard shortcuts for change background color in pdf and fill colors or number formats using this simple add-in.
It’s easy to use and will save you time. Have you been searching Google to find keyboard shortcuts to apply a font or fill color to a cell? 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. Unfortunately, there are no built-in keyboard shortcuts in Excel for font or fill colors.
But these built-in methods are either slow, or do not provide a direct solution. This add-in also lets you create keyboard shortcuts to apply other cell formatting properties like number formatting, borders, font size, protection alignment, etc. 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. 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. 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. In the video above I demonstrate a few different ways to apply different formatting types with the custom keyboard shortcuts. Then you get to choose the letter at the end of the key combination.
S is very easy to press because the keys are close together and can all be pressed at one time with your left hand. H, then pressing the arrow keys to find the color on the palette. That method is slow and difficult to perform. Formatting Shortcuts add-in are easy and efficient. They will save you a lot of time. 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. 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.
A to apply the formatting to a few cells. Finally, I undo my actions using the Undo button. The shortcut keys and cell formatting can be changed with the click of a few buttons. Any combination of formatting properties can be applied with a keyboard shortcut.
This includes custom styles and all formatting options. 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.
Improve your efficiency and style worksheets in a fraction of the time it would take with mouse actions. The add-in saves your styles so you can start using the keyboard shortcuts when you open a new workbook. Using the same styles throughout your models will make it easier for users to read and understand. The image below shows the Cell Styles menu. The add-in is available in two versions. Both versions are compatible with Excel 2007, 2010, and 2013.
It has a single undo feature, which allows you to undo your keyboard shortcut action one time. The Cell Styles and Undo History are two great features that I think you will find really useful. Formatting Shortcuts Excel Userform 2. 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.
If you are not satisfied, you may get a full refund within 90 days of purchase. Both versions include free upgrades and support. Formatting Shortcuts Product Comparisons 2. 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. The zip file contains: the add-in file, installation guide, and user guide.