Excel - Copy Row Heights (feat. Martijn Reekers ModelOff Finalist) - Episode 1609

4,234 views · Published 3 December 2012 · 2:53 · Indexed 30 October 2026

Channel: MrExcel.com · 2012 · Education

Watch on YouTube

Microsoft Excel Tutorial - Copy Row Heights in Excel.

Welcome to the MrExcel podcast, where we bring you the latest and greatest tips and tricks for Excel. In this episode, we are coming to you from New York City for the first ever ModelOff finals. We have 16 Excel experts from around the world competing for the title. I am your host, Bill Jelen, and I am excited to bring you an exclusive interview with one of the finalists, Martijn Reekers from the Netherlands.

Martijn shares with us his journey to the finals and how he discovered his love for Excel. He also reveals his secret trick for copying row heights, which is not available in the Paste Special function. By using the shortcut Alt+O+R+E and then hitting F4, Martijn shows us how to quickly and easily copy row heights without having to manually enter the numbers. This is a game-changing tip that can save you a lot of time and effort in your Excel work.

We wish Martijn and all the other finalists the best of luck in the competition tomorrow. And for those of you interested in participating in ModelOff, be sure to check out their website for information on the 2013 competition. The first two rounds can be done from the comfort of your own home or office, with a chance to win a trip to New York City for the finals. Thank you for tuning in to this episode of the MrExcel podcast, and be sure to subscribe for more Excel tips and tricks. See you next time!

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-on-youtube/


Table of Contents:
(00:00) Introduction to ModelOff Finals in New York City
(00:11) Interview with finalist Martijn Reekers
(01:01) Martijn's trick for copying row heights using Alt+O+R+E and F4
(02:19) Conclusion and invitation to participate in ModelOff 2013
(02:43) Clicking Like really helps the algorithm

This video answers these common search terms:
Alt+O+R+E shortcut in Excel
Copy column width in Excel
Copy row height in Excel
Excel financial analysis
Excel modeling tips
Excel paste special
Excel tricks and shortcuts
F4 shortcut in Excel
How to enter ModelOff competition
ModelOff 2013 competition
ModelOff competition
MrExcel podcast

This week, Bill is in New York City to judge the ModelOff  Worldwide Excel Championship! Today, he gets a cool tip from finalist Martijn Reekers on how to quickly 'Copy Row Heights'. Follow along with Episode #1609 to learn how its done!

ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year's competition, visit http://www.modeloff.com/modeloff-2013/

...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE2010.html

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153424/

More from this channel