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.
...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.
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.
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.
