Every other cell shading in g docs download#

_Ĭlick Here to Jump to Download Section Formatting Types Using the same styles throughout your models will make it easier for users to read and understand. No setup needed (even for custom styles).

Consistency – The add-in saves your styles so you can start using the keyboard shortcuts when you open a new workbook.

Save Time – Improve your efficiency and style worksheets in a fraction of the time it would take with mouse actions.

More details about undo on the help page. This add-in works around that to retain the undo history. If you have recorded or written your own formatting macros, you know that undo history is typically lost when you run a macro.

Every other cell shading in g docs full#

Full Undo History – The undo history is retained so you can undo any changes made by the keyboard shortcuts.

This includes custom styles and all formatting options.

Unlimited Options – Any combination of formatting properties can be applied with a keyboard shortcut.

Easy to Use – The shortcut keys and cell formatting can be changed with the click of a few buttons.

Here are a few additional features of the add-in: Finally, I undo my actions using the Undo button.Ĭlick Here to Jump to Download Section Features I then use the keyboard shortcut Ctrl+Shift+A to apply the formatting to a few cells. In this video I setup a shortcut key for a cell style that contains number formatting, borders, font, and fill colors. The screencast below shows an example of this. So you can use Ctrl+Z or the Undo button if you accidentally press one of the shortcut keys.

Every other cell shading in g docs full version#

The full version of the Formatting Shortcuts add-in allows you to retain the full Undo History in Excel. 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. The Formatting Shortcuts add-in also allows you to undo your mistakes. They will save you a lot of time.Ĭlick Here to Jump to Download Section Undo Your Mistakes That method is slow and difficult to perform.īut the Ctrl+Shift+ shortcuts you use with the Formatting Shortcuts add-in are easy and efficient. This beats alternative methods of having to press Alt+H+H, then pressing the arrow keys to find the color on the palette. 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. Then you get to choose the letter at the end of the key combination.įor example, in the screenshot below I have setup the shortcut Ctrl+Shift+S to apply the yellow fill color to a cell or range. The keyboard shortcuts you create all start with Ctrl+Shift. In the video above I demonstrate a few different ways to apply different formatting types with the custom keyboard shortcuts. You will see that it is fast to setup and easy to press the shortcut keys. Here is a video that explains how the add-in works. This will save you a ton of time over having to navigate to the ribbon (toolbar) with the mouse. The keyboard shortcuts are quick and easy to press in one step. The Formatting Shortcuts add-in will allow you to create keyboard shortcuts for any of these actions. It includes the buttons on the ribbon that we press over and over again to apply formatting. The image below shows some common tasks that we all do in Excel to format cells. Again, this includes any type of formatting and is not just limited to font and fill colors. The Formatting Shortcuts add-in will save you a lot of time if you are currently using the mouse to format cells. The add-in is named “Formatting Shortcuts” and there is a free version available for download.Ĭlick Here to Jump to Download Section Time Saving Shortcuts This add-in also lets you create keyboard shortcuts to apply other cell formatting properties like number formatting, borders, font size, protection alignment, etc. So I developed an add-in that allows you to create keyboard shortcuts to change the font & fill colors. Keyboard Shortcuts for Font & Fill Colors But these built-in methods are either slow, or do not provide a direct solution. There are a few “workaround” methods that I explain in another blog post, 5 Excel Keyboard Shortcuts for Font & Fill Colors. Unfortunately, there are no built-in keyboard shortcuts in Excel for font or fill colors.

This page will hopefully help you with some answers and solutions to this question. I have spent a lot of time researching this topic as well. Have you been searching Google to find keyboard shortcuts to apply a font or fill color to a cell?