QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to use Flash Fill in MS Excel 2016?

By Neha T Leave a Comment

It becomes laborious when we have repeated data to be fed in the Excel spreadsheet. Flash Fill reduces your work of entering the data manually in each cell. It also saves your time.  Flash Fill automatically fills the values in the cell. For that, you just have to type one or two examples that help in recognizing the pattern of output you require.

After recognizing the pattern of the examples, the flash provides you with the advised list as your Google search engine does when you start writing on the search box it advises you with a list of relevant searches.  With the help of Flash Fill, you can split the information in a cell, or you can also club the information present in two separate columns. So, let’s start with the steps below to learn How to Use Flash Fill in MS Excel 2016 ?

Steps to Use Flash Fill in MS Excel 2016:

Step 1: If, you want to use flash fill. First, you have to turn ON the Automatic Flash Fill and for that open a document in MS Excel 2016. Now, go to File tab and click Options button.

flash-fill-step-1-Step 2: It will pop up Excel Options dialog box. In the image below you can see on the left side of Excel Options dialog box, there is Advanced tab click the Advanced tab.

flashfill-step2Step 3: Under Editing options you will find Automatic Flash Fill checkbox. Click on Automatic Flash Fill checkbox to turn it ON.

flashfill-step3

Or instead of above three steps, you can directly turn ON the Flash Fill, for that go to the Data tab and click on Flash Fill button under Data Tools group.

flashfill-step3-1

Or You also have the easiest option among all press Ctrl+E to get Flash Fill ON.

Step 4: In the image below you can observe a spreadsheet that has a list of First name and Last name of some persons in two different column. Now, I want to club the First Name and Last Name of each person in a new column. For that start writing the Full name of the first person as I wrote George Abbot in a cell when you start to write the second full name till then Excel’s Flash Fill has recognized your writing pattern and will advise you the entire list clubbed first names and last names.

flashfill-step4If you agree wth the advised list, click enter.

Step 5: You will observe the output as the filled column with Full names of the persons. It reduces your headache of writing each full name one by one in the column.

flashfill-step5Hope the content was useful. Keep reading.

You Might Also Like:

how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? how-to-freeze-row-and-column-in-ms-excel-in-2016-featured-imageHow to Freeze Rows and Columns in MS Excel 2016? how-to-split-text-of-cells-in-ms-excel-2016-featured-imageHow to Split Text in a Cell in MS Excel 2016? Auto Fill in MS Excel 2016How to use Autofill in MS Excel 2016? how-to-sort-data-in-ms-excel-2016-featured-imageHow to Sort Data in Ms Excel 2016? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? how-to-create-macro-in-ms-excel-2016-featured-imageHow to Create Macros in MS Excel 2016? how-to-delete-macro-in-ms-excel-2016-featured-imageHow to Delete Macro in MS Excel 2016?

Leave a Reply Cancel reply

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

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to add or remove “Most Used List” items from the Start menu in Windows 10
  • How to find out package details of an application in Ubuntu 14.04
  • How to Update Google Chrome?
  • How to Disable Right Click on Wordpress using Plugin
  • How to batch rename files in Ubuntu 14.04

Copyright © 2023 · QueHow · Contact Us