![]() This article explains all the possible ways to apply font or fill (background or shading) colors using keyboard shortcuts, including a way to customize your own. I have done extensive research on this issue, and this article is a collection of all the solutions you will find on the web. So this should save you some time in your search for an answer. The shortcuts presented here are for Excel for Windows versions 2007, 2010, & 2013. Do you want the Good News or Bad News First? Well, I'll give you the bad news first to get it out of the way There is no keyboard shortcut in Excel that directly applies a font or fill color to a cell. Sorry I have to be the one to tell you that. ![]() Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula. But the good news is that there are a few workarounds that will get you close. And the better news is that I have developed a simple (free) solution that will allow you to easily customize your own keyboard shortcuts for font and fill colors. Overview of the Font Fill Color Shortcut Solutions In the first part of this article I will explain all the built-in keyboard shortcuts that will help you apply font and fill colors. Since there is no direct way, I consider these to be workaround solutions (#1-#4 below). Even though these workarounds won't directly solve your problem, there are some great tricks to learn here to help save you time. The ultimate goal of using a keyboard shortcut is to save time. Especially for repetitive tasks when you need to quickly apply the same colors over and over again. Changing password in outlook for mac. None of the workaround methods really accomplish this, so I created an Excel add-in that will allow you to customize your own shortcuts. The add-in is explained in #5 below with a link to the download page. Here is an outline of the article: • (workaround) • (workaround) • (workaround) • (workaround) • (custom solution) Step-by-step instructions and the pros & cons of each of these methods are provided below. #1 Open the Color Palette Menus with Alt+H+ The keyboard shortcut to open the Fill Color menu on the ribbon is Alt+H+H. Microsoft business install link for mac. This will open the menu so you can view the color palette, but you have to take additional steps to select and apply the color. Canon mp495 software for mac. You can use this scanner on Mac OS X and Linux without installing any other software. If you haven't installed a Windows driver for this scanner, VueScan will automatically install a driver. VueScan Mobile also works with this scanner on the iPad, iPhone, Android and Kindle Fire. VueScan is compatible with the Canon MP495 on Windows x86, Windows x64, Windows RT, Windows 10 ARM, Mac OS X and Linux. If you're using Windows and you've installed a driver, VueScan's built-in drivers won't conflict with this. Here is a quick guide: • With the cells selected, press Alt+H+H • Use the arrow keys on the keyboard to select the color you want. The arrow keys will move a small orange box around the selected color. • Press the Enter key to apply the fill color to the selected cells. Alt+H+F+C is the shortcut for the Font Color menu and functions the exact same as the Fill Color menu. Pros: • You can select a color from the menu using only the keyboard. • Any color on the color palette can be applied relatively quickly. • There is a direct shortcut for “No Fill” – Alt+H+H+N Cons: • This method is SLOW. It's really a three step process, and even more time consuming if your color is at the bottom right side of the color palette. • There is a lot more room for error because you are required to press the arrow keys multiple times. • Font colors are even harder to apply because the shortcut (Alt+H+F+C) contains an additional letter. #2 Quick Access Toolbar (QAT) The Fill Color and Font Color menus can be added to the Quick Access Toolbar (QAT). This will help make the keyboard shortcut to access them shorter. Instead of pressing Alt+H+H, you could put the Fill Color menu in position #1 of the QAT and use the shortcut Alt+1 to open the Fill Color menu. See my articles on and for instructions on this. Once the menu is open you still have to use the arrow keys to select your color. It's basically the same three step process as above. Pros • This is faster than the Alt+H+H(FC) methods because you can eliminate at least one key stroke. • If you are using the Font or Fill Color palettes frequently it might be nice to have them on the QAT. This way you can access the menus with the mouse without having to navigate to the Home tab on the ribbon. Cons • It's still slow and requires you to use the arrow keys to select your color. #3 F4 Key or Alt+Enter The F4 key is a great keyboard shortcut to know and can save you time. The F4 key will repeat the last action you've taken in Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |