- Select the cell from which the format is to be copied.
- Press Ctrl+C. This copies the cell to the Clipboard.
- Select the cells to receive the format.
- Press Shift+F10, S, R. This sequence displays the Context menu and selects the options to paste just formatting.
For those of you who love to use the Format Painter but are a fan of keyboard shortcuts, here are the shortcut keys to use. Excel doesn't provide a single shortcut key you can use for the Format Painter. You can, however, use the following steps: