March 1, 2016
Hi fellow Excel Addict,
Now this is the kind of winter I like.
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)
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.
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).
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.
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).
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.
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.
' PasteSpecialColumnWidths Macro
' Created by Francis Hayes (The Excel Addict)
' Keyboard Shortcut: Ctrl+Shift+W
On Error Resume Next
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630