Learn Excel - Column Width and Row Height: Podcast #1393

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Apr 28, 2011.
Today, Wayne from Kentucky points out that you can quickly adjust Column Widths using the Paste Special Column Widths tool. He laments that there is not a similar tool for copying Row Heights. In Episode #1393, Bill shows us how to copy Row Heights as well.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

For more Excel 2010 knowledge, check out "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
maxresdefault.jpg


Transcript of the video:
The MrExcel podcast is sponsored by Easy Excel.
MrExcel podcast episode 1393 column widths row heights. Well, Hey, welcome back to the MrExcel net cast. I'm Bill Jelen. I got a note from Wayne in Kentucky. Wayne is talking about column wits and how cool it is that pay special now includes a way to copy column with, so if you want to copy those column with somewhere else, just select those three cells copy and then paste special.
Traditionally that's all E S and then right there, column widths. We'll copy those columns over and do that. We can also a copy and then use paste this one right here, the key source column widths, which we'll copy those whatsoever. But we noted that unfortunately, there really isn't a good way to use pay special to copy row Heights. So there we have, let's go with a short row and then a taller, if you wanted to copy those real height somewhere there is no pay special row Heights.
Why, but great trick for Wayne. I'm going to choose those rows right there, those three rows, and we're going to use the format painter or the format painter we'll copy row Heights. I'm selecting all three rows, and then I have to go with the paint brush and select three more rows. So like select all three, and that will copy the row Heights, just like the original dataset, unfortunately, and also copies bold and all the other colors and things like that. So it works great if the work book is new. So a couple of different ways there pay special column widths or the format painter to copy real Heights. Of course, the format painter also works with copying column widths, copied the original call, this a lots of different ways to take a range of columns or range of row Heights.
Hey, I want to thank you for stopping by the next time for another net cast from MrExcel.
 

Forum statistics

Threads
1,213,546
Messages
6,114,253
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top