How to use Flash Fill or Auto Fill command in Excel

Flash Fill is an important and useful command of Microsoft Excel. By default Flash Fill command is turn on and it used to automatically fill the data when it senses a pattern. In this guide we have to discuss how to use Flash Fill or Auto Fill command in Excel.

Flash fill is treat just like automatic fill command. During typing any value which is matched with already filled value rest of the values are automatically fill the cells. This will happen only when automatic fill or flash fill command is activated on Microsoft Excel.

Must Read: How to Age calculation From Date of Birth – MS EXCEL

How to use Flash Fill or Auto Fill command in Excel

How to use Flash Fill or Auto Fill command in Excel

Flash Fill or Auto Fill command is an important command of Microsoft Excel. Most of the users have to face auto fill or flash fill experience during working on Microsoft Excel. By default Flash Fill or Autofill command already turn on in the Microsoft Excel. Sometime Flash Fill command doesn’t start automatically during the typing the data which match the already filled pattern, then you have to use manually process. You have to take few given steps which helps you to use Flash Fill or Auto Fill in Excel.

Step 1: Type the following given pattern as per given worksheet or you can also draw another required sheet.

How to use Flash Fill or Auto Fill command in Excel

Step 2: Type the first cell content in another cell. Select the range from cell B2 to B7 and click on the Home tab > Fill > Flash Fill. You can also press ALT+HFIF shortcut key to quickly fill the matched result in rest of the selected cells. If Flash Fill doesn’t working properly then you have to use manually process by pressing Ctrl+E Shortcut key to get the result.

Must Read: Highlight Current Month Birthdays in Excel 2013

Note: If Flash Fill doesn’t activated on your Computer or Laptop then you have to take given path to turn on Flash Fill feature on Microsoft Excel. You have to click on the File > Options > Click on the “Advanced” option > Turn on “Automatically Flash Fill” on right side pan. Finally click on the OK button.

I hope after reading how to use Flash Fill or Auto Fill command in Excel article you can easily understand the importance of Flash Fill or Auto Fill command. If you have any suggestion regarding this article then please write us in the comment box. Thanks to all.

Leave a Reply

Your email address will not be published. Required fields are marked *