Skip to main content

how to do flash fill in excel with example video 2020

 A new feature in Excel 2013,Flash fill can enter data automatically into your worksheet.It can save your time and effort .flash fill can guess what kind of information you're entering into your worksheet.

Flash fill can finish your work for as soon as it detect what you want to do.


Shortcut key: ctrl+E


process of  how to turn on flash fill 

Flash fill can automatically fills your data when it sense a pattern for that you need to turn on flash fill.

go to file option

click on advanced and make sure the automatically flash fill box is checked.








Example 1 

In the below picture we have to write First Name ,Middle Name and last name separately . Here we can use flash fill .

  First ,let the Excel know what you want to do by entering the "rohan" into cell B3"kumar" into cell C3 and "jaiswal"into D3.


Go to the Data tab click Flash Fill or(press Ctrl+E)



Result



Example 2

Here we have to write separately state code ,pan card and zonal area code.write "25" in cell D4, "ABDFS1324" in cell E4 and  "1Z5"  in cell F4.


                                                                                      
                                                                               

                                                                                            

Go to the Data tab click Flash Fill or(press Ctrl+E)



 more Example in this video










Comments

Popular posts from this blog

2021What are the four types of cell references in excel with example video.Relative, Absolute,mixed,circular

 Most formula you create including references to cell or ranges . These references enable your formula to work dynamically with the data contained in those cells or ranges rather than being restricted to fixed value . For example, if your refers to cell  A1  you change the value contained in  A1 ,  the formula result changes to reflect new value . If you didn't use references in your formula , you would need to edit the formulas themselves in order to change the value use in the formula .  there are mainly four type of cell references.                                         Relative cell reference  it refers to the cell by their position in relation to the cell that contains the formula . The row  and column references can change  when you copy the formula to another  cell because the references are actually offsets from the current row a...