Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365


November 29, 2016

Hi fellow Excel Addict,

In today's 'Excel in Seconds' tip, I'm going to show you 'The Format Painter Pattern Swipe'. You've never heard of it? OK. I made up that name but it IS exactly what it is and, once again, this is one of those neat tricks that Excel can do that most have never seen before.

And if you missed last Thursday's 'Excel in Minutes' tip, 'How To Recover A Workbook That You Forgot To Save Changes To', you can read it here now.

Please feel free to share my newsletter with your Excel friends — they will thank you for it.

Hope you're having a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)


TheExcelAddict.com Quote of the Day

"No matter how many mistakes you make
or how slow you progress,
you're still way ahead of everyone who isn't trying"

-- Tony Robbins --





If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

The Format Painter Pattern Swipe

You probably already know about tha Format Painter for quickly copying formatting. Select a formatted cell or range, click Format Painter (Home tab), then select another cell or range to apply the same formatting.

Did you also know that after selecting the formatting to be copied, you can double-click the Format Painter and apply the formatting to multiple ranges by consecutively selecting each range...then click the Format Painter tool (or press Escape) to turn it off? You probably knew that too.

Well, here's something most Excel users don't know about Format Painter.

If you want to copy the formatting from a small range of cells and apply the same pattern to a larger range of cells, do you double-click the Format painter and then click multiple times... each time applying the formatting to a range the same size as the original range? That's what I see most Excel users do...and that's the way I did it for years.

Format Painter Copy Formatting in Microsoft Excel 2007 2010 2013 2016 365

But you don't have to do it that way. There is another faster and easier way.

Because the Format Painter recognizes patterns when you select a range of cells, you can quickly apply the same pattern across a larger range simply by dragging the Format Painter across the larger range with one swipe.

Click And Drag Format Painter To Copy Formats in Microsoft Excel 2007 2010 2013 2016 365

The result is......

Format Painter Pattern Recognition in Microsoft Excel 2007 2010 2013 2016 365

The same formatting pattern is extended across the larger selection regardless of its size and dimensions.


Learn how to build an Excel Dashboard in 1 hour

Thanks for supporting this newsletter and website

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630