FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


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

March 1, 2016

Hi fellow Excel Addict,

Now this is the kind of winter I like.

Francis Hayes (TheExcelAddict.com)
You may think that 10C (50F) is nothing to get excited about, but compared to the February weather we typically get  in Newfounland (look here), this year has been fantastic. It hasn't all been 'bright sunshiny days', but every day that I don't have to shovel snow is a good winter day.

Tuesday again and time for 
another 'Excel in Seconds' tip to help you get your work done faster and smarter.

If you missed last Thursday's 'Excel in Minutes' tip where I showed you how 'Awesome Sparklines Will Quickly Spot Trends in Your Data', you can 
find it here.

If you have a favourite tip, or a problem that you've been trying to solve, that I
could possible share in my newsletter, please send it along to me.

I hope you enjoy the rest of your week.

Take care and keep Excelling,

Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)

TheExcelAddict.com Quote of the Day

"When obstacles arise, you change your direction to reach your goal,
you do not change your decision to get there."
-- Zig Ziglar --



To view this newsletter online click here.

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

You can access even more tips on my website by going to my members' page

To update your contact info, click the 'Change Subscriber Options' at the bottom of this email.



Excel in Seconds with TheExcelAddict.com

Copy Column Widths

When you Copy a range of cells and paste them somewhere else, all of the data and formatting gets pasted but the column widths don't (unless you've selected the ENTIRE columns).

Column Widths Not Copied_in_Microsoft_Excel_2007_2010_2013_2016_365

There may be times when you want the columns widths to be copied along with your data. Or maybe you just want to duplicate the column widths from one part of your worksheet to another.


Well, there is a way to paste
the column widths along with the data and formatting or paste just the column widths. It's been there all along but it's well hidden in Paste Special options.

Copy And Paste Column Widths_in_Microsoft_Excel_2007_2010_2013_2016_365

To paste the column widths AND the data and formatting

After copying the cells, click the small arrow below the Paste command on the Home tab. Then, from the Paste options, choose
the Keep Source Column Widths button (2nd button on the 2nd row).

Copy Column Widths Data And Formatting_in_Microsoft_Excel_2007_2010_2013_2016_365

To paste just the column widths

After copying the cells, click the small arrow below the Paste command on the Home tab, 
click Paste Special... and, from the Paste Special dialog, select the Column Widths option and click OK.


Copy Just Column Widths_in_Microsoft_Excel_2007_2010_2013_2016_365

Paste Column Widths Macro
If you're familiar with macros and VBA, here is a macro that I use to make copying column widths even easier.
I have assigned this macro to the keyboard shortcut CTRL+SHIFT+W.

Sub PasteSpecialColumnWidths()
'
' PasteSpecialColumnWidths Macro
' Created by Francis Hayes (The Excel Addict)
' TheExcelAddict.com
'
' Keyboard Shortcut: Ctrl+Shift+W
'
    On Error Resume Next
    Selection.PasteSpecial Paste:=xlPasteColumnWidths
End Sub


Thanks for supporting this newsletter and website


FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

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