3 Simple Ways to Copy Column Widths Perfectly

[@kraftedhomes8846]

Are you FREAKING KIDDING ME???? I've been so annoyed for YEARS because my column width never translated . . . I thought it was just me, because I never heard anyone else complaining about it. Thank you for always showing me quick and easy ways to do my job! Sumit, you're my hero!!

[@rgsmess]

Oh my gosh! Why didn't I learn this twenty years ago!

[@IvanCortinas_ES]

Yes. Great ways both of them. Thank you Sumit!!

[@billflock6267]

Life changing...thank you!

[@bostjanklemencic]

Great tip, thanks a lot!

[@vaibhavkumar2054]

Really Informative Thanks

[@zahoorsarbandi2982]

very nice and useful information

[@ramruttunaubeeluck9235]

3:06 awesome

[@bjbrooks]

Love it! Thank you :)

[@beatamarszaek7115]

Thank you for this fantastic tip! It has been such an irritating detail in Excel. So far I have used the icon for copying the original source, but it never worked with columns. And the solution has been so close :)

[@jhankhanajani9314]

Thank you Sumit !!

[@WekomVideos]

So cool. It's so simple but I didn't know it existed. Great video as always, Sumit, thank you s much for your excellent videos!

[@SurendranNambiath]

Great Tip Sumit! Keep Going! All the Very Best!

[@Satwant2463]

Thank you Sumit 👍🏼

[@MiRofek]

Great tutorial. How can also copy paste the row heights?

[@usercsk]

Excellent - Very useful !!

[@MaureenPesch]

I feel so stupid- how many times have I seen that paste special menu and never noticed the column width option??? Thank you!!!

[@LS-zo3cr]

For me I usually use shortcuts: ctrl C and then ctrl alt V + W (for the width of column)

[@gowthammaditati64]

Hi sir , How to do calculate sum of alternate rows / columns having huge data ?

[@michaellundsrensen2292]

I would click on the triangle between A and 1 and paste the sheet i Sheet 2.

[@supinderbabra7068]

GREAT VIDEO as always. Thank you! A question for all My ALT E S W does not work. I keep getting a message that ALT E is not there. Has anyone run into this issue?

[@trumpexcel]

You can also open the Paste Special dialog box using Control + Alt + V (hold both Control and ALT key and then press V). Then use the W key to select the column width option.

[@supinderbabra7068]

@@trumpexcel Thank you. I need to get a list of all the shortcuts next to me.

[@soundaryasuresh1845]

Sir dashboard videos example files can't be assessed. Could u make it accessible sir?

[@suresh1957]

For a moment, I thought it was some nonsense from the notorious Trump University or associated in some way with Donald Trump. Luckily, I did not skip and learnt something very useful. Thanks very much!

[@neha-ky3jq]

hi i am not getting take and drop functions in my excel .. please guide me

[@md.habiburrahman2125]

Sir, please pivot table topics vedio

[@dondgc2298]

This method does maintain column width but it seems that if you want the column width, row height and ALL formatting (ie, formatted as table, font colors etc) the only way to do it is to select the entire worksheet. Please prove me wrong as I would really like an easier solution than copying everything and trimming down to just what I want. Or copying a limited selection and reformatting everything. And of course if there is already data in the sheet pasting “everything” is a problem. Hopefully someone will point out a way to do this.

[@frachiar4444]

I use a simplest way: Just Copy the whole colums, instead of the limited range.

[@Raghav461]

Oh so that also automatically adjusts to the source column width, is it?

[@manosvenianakis9323]

Ctrl + W seems faster

[@trumpexcel]

Control + W closes the workbook. Not sure how to use it to copy paste column width

[@manosvenianakis9323]

@@trumpexcel my description was not good. after ctrl + V, then ctrl again for pop up menu. shortcut is W. (not ctrl + W at the same time)

[@trumpexcel]

@@manosvenianakis9323 yeah, that's a good way to do it. Thanks for sharing

[@SohamUzumaki07]

Alt+H+o+i