Excel - Column Width and Row Height: Episode 1393
Microsoft Excel Tutorial: Why No Paste Special to Copy Row Heights in Excel?
Welcome back to the MrExcel podcast, sponsored by Easy Excel. In this episode, we will be discussing column widths and row heights. I recently received a note from Wayne in Kentucky, who pointed out the new feature in Excel that allows us to easily copy column widths. All you have to do is select the cells you want to copy, and then use the paste special function. This can save a lot of time and effort, especially when working with large datasets.
However, Wayne also brought up a valid point - there is no easy way to copy row heights using the paste special function. This can be frustrating, especially when dealing with rows of varying heights. But fear not, I have a great trick for you. You can use the format painter to copy row heights. Simply select the rows you want to copy, and then use the format painter to select the rows you want to paste the heights onto. This will not only copy the row heights, but also any formatting such as bold or colors.
It's important to note that this trick works best with new workbooks. If you are working with an existing workbook, the format painter may also copy over any existing formatting, which may not be desired. In that case, you can use the paste special function for column widths, or manually adjust the row heights. The format painter is a versatile tool that can also be used to copy column widths, making it a great option for copying ranges of columns or rows. Thank you for tuning in to this episode of the MrExcel podcast, and be sure to join us next time for more Excel tips and tricks.
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents:
(00:00) Copying Column Widths with Paste Special
(00:24) Using Format Painter to Copy Column Widths
(00:39) No Option to Copy Row Heights with Paste Special
(00:52) Using Format Painter to Copy Row Heights
(01:03) Alternative Methods for Copying Row Heights
(01:15) Using Format Painter to Copy Row Heights
(01:28) Limitations of Using Format Painter for Row Heights
(01:41) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
Copy column widths
Copy row heights
Copying column widths with format painter
Copying row heights with format painter
Easy Excel sponsorship
Format painter
Net cast from MrExcel
New workbook
Paste special column widths
Range of columns
Range of row heights
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
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.
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.
Смотрите видео Excel - Column Width and Row Height: Episode 1393 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MrExcel.com 28 Апрель 2011, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 14,946 раз и оно понравилось 49 людям.