Look Who it Was Random video

Excel - Mastering Excel's Fill Handle: Data Entry and Extending Data Series Tips! - Episode 471

620 views · Published 11 May 2009 · 2:48 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Mastering Excel's Fill Handle: Data Entry and Extending Data Series Tips!

Welcome to the latest episode of the Learn Excel netcast! I'm your host, Bill Jelen, and today we have a special guest joining us at The Museum of Flight. Curtis Frye, from thatexcelguy.com and author of Microsoft Excel 2007 Step by Step, is here to share some valuable tips on data entry and extending data series using the fill handle.

Have you ever needed to quickly enter a series of data, such as months or numbers? Curtis shows us a handy trick to do just that. By simply dragging the fill handle in the lower right corner of the active cell, you can easily fill in the rest of the series. But did you know that you can also use the fill handle to repeat a value? Just hold down the control key and hover over the fill handle to see the cursor change to a black crosshair with a smaller black crosshair. This secondary behavior allows you to repeat the value as many times as you need.

But that's not all the fill handle can do. Curtis also demonstrates how to extend a data series using linear regression. This is especially useful when creating charts and trendlines. By selecting all the cells containing the values and dragging the fill handle, Excel will automatically fill in the rest of the series based on the best progression it can determine. This can save you a lot of time and effort, so make sure to take advantage of this feature.

I hope you enjoyed this tip from Curtis Frye and learned something new about the fill handle. Don't forget to tune in tomorrow for another episode of the Learn Excel netcast with MrExcel. And if you found this video helpful, be sure to give it a thumbs up and leave a comment below. Thanks for watching!

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/


Todays guest podcaster is Curt Frye, author of the Step by Step series for Excel. Curt shows off some cool fill handle tricks. Episode 471 shows you how.

Table of Contents:
(00:00) Introduction to Learn Excel Netcast
(00:20) Entering data quickly with the fill handle
(01:04) Repeating values with the fill handle
(01:37) Extending a data series using linear regression
(02:17) 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:
Controlling sort order in Pivot Tables
Custom list in Pivot Tables
Customizing appearance in filter area of Pivot Tables
Customizing appearance in report filter of Pivot Tables
Drag and drop in Pivot Tables
Moving fields in Pivot Tables
Pivot Tables
Sorting by revenue in Pivot Tables
Sorting in Pivot Tables
Sorting in report filter of Pivot Tables
Sorting in row label area of Pivot Tables
Sorting in the filter area of Pivot Tables

This video answers these common search terms:
Excel data entry shortcuts
Excel learning resources
Excel MVPs
Excel tips and tricks
Extending a data series in Excel
Linear regression in Excel
Microsoft Excel 2007
Repeating values in Excel
Saving time with the fill handle
Using the fill handle in Excel
Using trendlines in Excel


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

More from this channel