 Are you tired of wasting time manually rewriting lists of data? Rod here. This video will show you how Excel 2016 Flash Fill can save you time and frustration when working with lists of data. First, be sure to check if the Flash Fill option is defaulted to being automatically turned on or not. Do this by clicking on the File menu and scroll down and click Options. Then click on Advanced Options on the left. Then look under the Editing Options to make sure that the automatically Flash Fill is checked. Click OK if this is correct. Now let's learn how to use Flash Fill. When your data has a consistent pattern and you want to rewrite your data, Excel will identify the pattern and start Flash Fill. Flash Fill then figures out the pattern and will completely rewrite your list of data automatically. For example, here's a list of names with last name first followed by the first name. Let's say you want to rewrite the list but with first name followed by the last. Instead of rewriting the entire list, type the first name in the top cell of your new name column. Flash Fill will recognize the pattern and fill in the rest of the list in gray print. If you're OK with this gray print, which is a suggested list by Flash Fill, then just hit Enter. And Flash Fill will rewrite the entire list automatically. Think about the amount of time you saved and frustration you avoided even with this small list. Imagine those savings if this list contained a thousand names or more. You can also access Flash Fill by using a keyboard shortcut. Fill in the first cell in your pattern that you want for your data. Select the cell and press Ctrl plus E. Flash Fill automatically completes the list. Another way still to access Flash Fill is to select the cell and click on the data tab. Then scroll over to the right and click on Flash Fill in the Data Tools section. Your list is completed automatically. OK, now you'd know all about saving time and avoiding frustration by using Excel 2016 Flash Fill. If this video was helpful, please comment and share it with your friends. If you have questions or want coaching support, just click our coaching link and subscribe to our channel and receive our upcoming videos. Thanks for watching.