Look Who it Was Random video

Excel - Copy Column Widths in Excel with this Time-Saving Trick | MrExcel Netcast - Episode 698

366 views · Published 19 February 2009 · 2:03 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Copy Column Widths in Excel with this Time-Saving Trick | MrExcel Netcast.

Welcome back to the MrExcel netcast! In today's video, we're going to talk about a handy trick for copying column widths in Excel. As many of you know, using the format painter is a great way to copy formatting, including column widths. But did you know there's another option that can make this process even easier?

If you're using Excel 2003 or newer, there's a new option in the paste special menu that allows you to copy column widths. This can be a real time-saver, especially if you have multiple columns to copy. In the past, manually adjusting each column width could be a slow and tedious process, but with this new feature, it's a breeze.

Let's say you have a set of columns that you need to copy to another worksheet. Instead of manually adjusting each column width, simply select the first row of cells and copy them to the clipboard. Then, go to the sheet where you want to adjust the column widths and select the corresponding cells. In the paste special menu, you'll see an option for column width. Click on it and Excel will automatically adjust the columns to match the original data set. It's that easy!

This trick is especially useful if you have a large number of columns to copy, each with a different width. It can save you a lot of time and frustration. So next time you need to copy column widths in Excel, remember this handy tip. Thanks for watching and be sure to tune in for more helpful netcasts from MrExcel. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Say that you need to copy column widths from one range to another range. The Paste Special dialog now offers the opportunity to paste column widths from one range to another range. Episode 698 will show you how.

Table of Contents:
(00:00) Introduction to copying column widths
(00:17) Using the format painter for copying column widths
(00:27) New option in paste special for copying column widths
(00:37) Tedious process of manually changing column widths
(00:47) Using the border to determine column width
(00:58) Copying and pasting cells to fix column widths
(01:17) Using paste special to quickly fix column widths
(01:41) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Changing column widths in Excel
Copying and pasting column widths in Excel
Copying column widths between worksheets in Excel
Copying column widths in Excel
Copying columns in Excel
Excel format painter
MrExcel netcast on copying column widths
Paste special options in Excel
Quick solution for copying column widths in Excel
Tedious process of copying column widths in Excel
Time-saving technique for adjusting column widths in Excel
Using paste special to copy column widths in Excel 2003


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152212/

More from this channel