How to Use Flash Fill in Excel - Tutorial

In this Excel tutorial, we'll go over what Flash Fill is and how to use Flash Fill in Excel.

What is Flash Fill?
Excel Flash Fill works by detecting patterns in formatting and then applying it to other cells.

How to Use Flash Fill?
To use Flash Fill, all you have to do is type 1 or 2 examples of how you'd like for your data to look in a cell adjacent to the last column of the data that you're reformatting. Then, Flash Fill will work to recognize the pattern and autofill the other cells in that column to reflect the pattern.

Once you see the pattern begin to autofill, you can simply press Enter to make the changes or use the Ctrl+E keyboard shortcut to apply the Flash Fill formatting.

Click here if you would like to read our step-by-step article on this: https://yacostasolutions.com/flash-fill-in-excel/

If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/

*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://yacostasolutions.com/MS365

The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://yacostasolutions.com/camtasia

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊

To catch our Excel tutorials as they come out, subscribe to this channel by clicking: https://yacostasolutions.com/youtube

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials

Тэги:

#how_to_use_flash_fill_in_excel #how_to_use_flash_fill_in_excel_2016 #flash_fill_in_excel #flashfill_on_excel_2016 #flash_fill_on_excel #flash_fill_on_excel_2016 #flash_fill_excel_2016 #what_is_flash_fill_in_excel #excel_flash_fill #excel_flash_fill_tutorial #excel_flash_fill_shortcut #excel_2016 #excel_tutorial #excel_tutorials #ms_excel #microsoft_excel #yacosta_solutions

Скачать видео