Autoplay Next video from Max length

Excel - Record Fill Down: Episode 1519

3,384 views · Published 23 February 2012 · 4:03 · Indexed 29 September 2026

Channel: MrExcel.com · 2012 · Education

Microsoft Excel Tutorial: How to Use the Macro Recorder to Record Fill Down in Excel.

Welcome back to the MrExcel netcast! In this episode, we will be discussing one of my favorite Excel features - the double click fill handle. However, have you ever tried to record this action using the Macro Recorder? If so, you may have noticed that it doesn't work as expected. But don't worry, in this video, we will show you how to use the Macro Recorder to successfully record the fill down action.

First, we will demonstrate the issue by recording a macro and attempting to use it on a larger data set. As you will see, the macro only records the action of copying down to the remaining records in the first day. This is not very useful, but we will show you a solution.

Next, we will try a different approach by turning off the Relative Reference initially and then using the Ctrl+down arrow and Ctrl+right arrow shortcuts to select the cells we want to copy down to. We will also introduce another handy shortcut - Ctrl+D, which is a shortcut for fill down. This method may seem like more work, but the advantage is that it will work no matter how many records there are.

So, if you're trying to record a macro and use the fill down feature, it is possible but you have to be in Absolute mode to enter the heading and first formula, and then switch to Relative mode to select the cells and use the Ctrl+D shortcut. This may seem like a lot of steps, but it will save you time in the long run.

Thank you for watching this episode of the MrExcel netcast. If you want to learn more about VBA and go beyond the Macro Recorder, be sure to check out our other videos. And don't forget to subscribe to our channel 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) Record Fill Down
(00:11) double click fill handle not recorded by macro recorder
(00:22) Recording a Macro to try and solve the problem
(00:33) First attempt: TryOne Macro
(00:47) Second attempt: TryTwo Macro
(01:02) Limitations of TryOne Macro
(01:19) Solving the problem with TryTwo Macro
(02:31) Using Ctrl+D shortcut instead of double clicking fill handle
(03:00) Advantages of using TryTwo Macro
(03:48) 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 formula
Ctrl+D shortcut key
Ctrl+Shift+A shortcut key
Ctrl+Shift+S shortcut key
Episode 1519
Excel-XL sponsorship
Fill handle
Macro Recorder
Record Fill Down
Relative References
VBA and Macro Recorder

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

Today Bill shows us how to use the Macro Recorder to record the action of Double-clicking the Fill Handle. It isn't as straight-forward as you might think, but it can be done with only the macro recorder. Follow along with Bill in Episode #1519 to learn how.

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

...Today's Podcast topic may be found in Bill's book, "VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy Syrstad. The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve...Includes crucial information on making Excel 2010 VBA code work with older versions.

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Excel - Record Fill Down: Episode 1519

More from this channel