Format Painter shortcut in Microsoft Excel

I’ve been working in Excel a lot the past weeks and often need to fix the formatting. A nice little trick to copy the formatting for a cell, row or column is the format painter, but it’s a hassle to keep clicking on all the ribbons to actually press the button! It was one of the few things in Excel where I would use the mouse.

 

Screenshot - Microsoft Excel - Format Painter
Screenshot – Microsoft Excel – Format Painter

 

There is an easier way to “Format Paint”:

Right click Format Painter, and click “Add to Quick Access Toolbar”, as shown in the next screenshot:

 

Screenshot - Microsoft Excel - Format Painter - Add to QAT
Screenshot – Microsoft Excel – Format Painter – Add to QAT

 

After this step, you will have a small button at the top of your screen with the Format Painter, which you can access via “Alt + <<NUMBER>>”,

in my case it’s “ALT + 4”:

 

Screenshot - Microsoft Excel - Format Painter in the QAT
Screenshot – Microsoft Excel – Format Painter in the QAT

 

Advertisements

One thought on “Format Painter shortcut in Microsoft Excel

  1. I think about how come you branded this specific post, How To Make Roman
    Shades “Format Painter shortcut in Microsoft Excel | Joris Visscher”.
    In either case I personally adored the article!I appreciate it-Luella

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s