In Excel you do not need to change column widths one by one, you can change multiple column widths all at the same time. We saw in a previous post how to change the standard width of all columns on one worksheet.
In this post we cover three neat tricks to help you change the width of many columns all in one go. Read on to find out more…
Select multiple columns then change column widths
Select all cells then change column widths
Few Excel users know that you can copy multiple column widths in Excel by selecting a range, copying it and then pasting the width of the columns to another range, using Excel’s Paste Special command. This technique is available in Excel 2007 & 2010, however it can be troublesome when there are merged columns.
Here are the two data sets with different column widths
1. Let’s say we have a data set in range B2:E12 with column widths we want to copy…
2. …over to a second data set in range H2:K12.
Select the columns you want to change
3. Copy columns B:E
4. Select columns H:K, right click to bring up the context menu, select paste special
Excel Paste Special Dialog Box for Column Widths
5. In the Paste Special dialog box, go to the Paste section → Column widths
6. Click OK to close the Paste Special dialog box.
Victor expertly teaches Microsoft Excel to people all over the world. He has millions of views of his popular Excel explainer videos on YouTube. These show time-saving shortcuts and real-world applications explained with easy-to-follow visuals.
Victor has over 20 years of experience using Excel as a professional for Big 4 Audit Firm Deloitte and two global tech companies. He knows firsthand that being more productive with Excel can lead to greater job satisfaction and career growth.
Discover the PROVEN Blueprint for transforming your Excel skills, supercharging your productivity, and standing out in your career! My course helps you to learn Excel VBA and save hours of time even if you have zero prior experience with programming.
Are you looking to up your spreadsheet game? Excel is an invaluable tool that can help you stay organized and save time. From data analysis to budgets, Excel can do it all!
Today, having Excel skills is more critical than ever. Those who know how to use Excel are more likely to find higher-paying jobs. And get promoted faster.