3 Simple Ways to Copy Column Widths Perfectly

Рет қаралды 5,949

Күн бұрын

When you copy and paste data in Excel, it copies everything except the column width. In this video, I will show you three simple methods you can use to copy column bits in Excel.
Read the article - trumpexcel.com/copy-column-wi...
00:00 Intro
00:12 Using Paste Icon options
01:00 Using the Paste Option in the Ribbon
01:20 Using Paste options in Right-click Menu
01:36 Using Keyboard Shortcut to Paste Column Width
01:58 Copy Column Width Only (without data)
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Пікірлер: 34

@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!

@vaibhavkumar2054 7 күн бұрын

Really Informative Thanks

@billflock6267 Ай бұрын

Life changing...thank you!

@IvanCortinas_ES Ай бұрын

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

@zahoorsarbandi2982 Ай бұрын

very nice and useful information

@bostjanklemencic Ай бұрын

Great tip, thanks a lot!

@ramruttunaubeeluck9235 Ай бұрын

3:06 awesome

@bjbrooks Ай бұрын

Love it! Thank you :)

@MiRofek Ай бұрын

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

@jhankhanajani9314 Ай бұрын

Thank you Sumit !!

@meetkcs Ай бұрын

Excellent - Very useful !!

@Satwant2463 Ай бұрын

Thank you Sumit 👍🏼

@SurendranNambiath Ай бұрын

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

@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!

@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 :)

@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 ?

@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?

@neha-ky3jq Ай бұрын

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

@user-dn5gd1rn9f Ай бұрын

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

@md.habiburrahman2125 Ай бұрын

Sir, please pivot table topics vedio

@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!

@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$