Shortcut Key for Format Painter

7/4/2020

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:

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.

Alan Salmon

catherine kimengele

8/4/2021 01:46:41 am

Very Helpful Thanks alot

GIDS SUNIL link

8/15/2021 01:20:51 am

Sir Thanx a lot for the short cut keys.

Very much helpful saves the time if keeps on practicing

puz link

12/3/2021 08:28:29 am

beauts, thanks

andrew

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

nall

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.

Authors

Ward Blatch
Ward provides consulting and training services as the Managing Director of K2E Canada Inc. He joined K2E Canada in 2005 and is responsible for the Canadian operations of this international consulting group, which provides professional development technology education for accountants across Canada and the US. Ward lives in rural Nova Scotia and can be reached at [email protected].

Tommy Stephens
Tommy is one of the shareholders in K2 Enterprises, affiliating with the Firm in 2003 and joining as a shareholder in 2017. At K2, Tommy focuses on creating and delivering content and is responsible for many of the Firm's management and marketing functions. Tommy resides in the metro Atlanta area. You may reach him at [email protected].

Randy Johnson
Randy is a nationally recognized educator, consultant, and writer with over 40 years experience in Strategic Technology Planning, Accounting Software Selection, Paperless, Systems and Network Integration, Business Continuity and Disaster Recovery Planning, Business Development and Management, Process Engineering and outsourced managed services. Randy can be reached at [email protected]

Bernie Smith
Bernie coaches businesses to develop meaningful KPIs and present their management information in the clearest possible way to support good decision making. As the owner of Made to Measure KPIs, he has worked with major organisations including HSBC, Airbus, UBS, Barclays, Credit Suisse, Lloyds and many more.

RSS Feed