- 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.
Shortcut Key for Format Painter
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:
8/4/2021 01:46:41 am
Very Helpful Thanks alot
8/15/2021 01:20:51 am
Sir Thanx a lot for the short cut keys.
1/23/2022 10:46:00 am
Didn't work for me. Are you supposed to press all the keys simultaneously? Does it work with only some Excel versions? I'm using MS Office for Mac via Office 365 subscription.
1/30/2022 04:54:45 pm
Does not work
6/9/2022 09:09:10 am
I prefer ctrl-Alt-V, which opens the paste special menu, which includes formatting too. Also a great way to paste values only.
Comments are closed.