Tag: Excel

  • 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