3 Simple Ways to Copy Column Widths Perfectly

Подписаться 375 тыс.

Просмотров 6 тыс.

50% 1

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: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Опубликовано:

7 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 34

@kraftedhomes8846 2 месяца назад

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 2 месяца назад

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

@IvanCortinas_ES 2 месяца назад

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

@bostjanklemencic 2 месяца назад

Great tip, thanks a lot!

@billflock6267 Месяц назад

Life changing...thank you!

@vaibhavkumar2054 24 дня назад

Really Informative Thanks

@zahoorsarbandi2982 2 месяца назад

very nice and useful information

@bjbrooks 2 месяца назад

Love it! Thank you :)

@ramruttunaubeeluck9235 2 месяца назад

3:06 awesome

@WekomVideos 2 месяца назад

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 2 месяца назад

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

@jhankhanajani9314 2 месяца назад

Thank you Sumit !!

@MiRofek 2 месяца назад

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

@Satwant2463 2 месяца назад

Thank you Sumit 👍🏼

@beatamarszaek7115 2 месяца назад

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

@meetkcs 2 месяца назад

Excellent - Very useful !!

@LS-zo3cr 2 месяца назад

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

@gowthammaditati64 2 месяца назад

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

@soundaryasuresh1845 2 месяца назад

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

@supinderbabra7068 2 месяца назад

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 2 месяца назад

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 2 месяца назад

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

@neha-ky3jq 2 месяца назад

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

@user-dn5gd1rn9f 2 месяца назад

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 2 месяца назад

Sir, please pivot table topics vedio

@suresh1957 2 месяца назад

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 2 месяца назад

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$