You can select it using a keyboard shortcut (Using the hotkeys for the ribbon tools and then hitting the keys F, P) On the Home tab, click Format Painter. MS Excel also has a useful format painter tool. If you want to paste a format, you can copy and use the keyboard shortcut to paste special (Ctrl + Alt + V).
Excel keyboard shortcut format painter how to#
The Alt key activates the keyboard shortcuts for ribbon commands, the H selects the Home tab of the ribbon, and the FP selects the Format Painter Follow the steps below to learn how to use a keyboard shortcut to accomplish the same thing: Select your text and simultaneously press CTRL + Shift + C to copy your formatting Select the text where you want the copied text formatting to be applied and press CTRL + Shift +V to paste your formattin Shortcut Key for Format Painter (Microsoft Excel These should not be pressed all at once, but in sequence. This action copies all of the formatting Press Alt, H, F, P. Let's say you select a whole paragraph and press Ctrl + Shift + C. To be exact, to use Format Painter, you press Ctrl + Shift + C to copy and Ctrl + Shift + V to paste. If you place the insertion point into a paragraph or select the entire paragraph, then Ctrl+Shift+C copies the formatting of the entire paragraph In fact, Format Painter is like a variation for the copy/paste shortcut you know well (Ctrl + C/Ctrl +V). You can, however, use the following steps: Select the cell from which the format is to be copied The shortcut for copying formatting is Ctrl+Shift+C and the shortcut for pasting is Ctrl+Shift+V. Unfortunately, Excel doesn't provide a single shortcut key you can use for the Format Painter.