If you have more Quick-Access Toolbar icons than what will fit, you will get a "More" icon. After 9 Quick-Access Toolbar icons, the numbers will be 09, 08, 07, and so on. If you want to go nuts with Quick Access Toolbar icons, here's how this works with lots of Quick Access Toolbar icons. That's your shortcut key combo now for Format Painter.īut if not, press the Alt Key, and you'll see the number key on your keyboard that you need to press to use Format Painter. You should now just need to press Alt and then 5. You've now added the Format Painter icon to the Quick-Access Toolbar. Open an Excel document, right-click the Format Painter icon, and select "Add to Quick-Access Toolbar." Now press Enter/Return. There's actually an alternative and *MUCH, MUCH* easier work-around:įirst, some quick set-up. Since the macro can be assigned to a shortcut key, you end up with an easier shortcut than what has already been discussed. To use the macro, follow steps 1 through 3 as previously outlined, and then run the macro. The following is an example of such a macro. If you prefer a real shortcut key (only a single key press), then you will need to develop your own macro to paste only the format. The first displays the Context menu for the cells and the other uses the regular menu system. In step 4 you could also press Shift+F10 rather than Alt+E. This sequence displays the Paste Special dialog box and chooses to paste only the format.
Select the cells to receive the format.Select the cell from which the format is to be copied.You can, however, use the following steps: Unfortunately, Excel doesn't provide a single shortcut key you can use for the Format Painter. He would find it much easier to use if there were a shortcut key instead. Fred loves to use the Format Painter, but doesn't like to use the mouse to use the tool.
0 kommentar(er)
