Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can I do in Excel Flash Fill ?

Programming Microsoft Excel Data Entry Computer Skills MS Office tools
user-image
Question added by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL
Date Posted: 2015/04/17
Upvote (1) Views (3) Followers (4) Answers (4) Report Question
Write an Answer
Register now or log in to answer.
Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL

the right answer is mr Reynaldo's answer

 

also u just can press CTRL + E  shortcut for flasfill

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

1-Click File > Options

2-Click Advanced and make sure the Automatically Flash Fill box is checked

3-Click OK, and restart your workbook

Reynaldo Corvera
by Reynaldo Corvera , Planner , Flexible Packaging

Flash fill is very useful  for integrating data without typing in each rows.

Like title (Mr.Ms., Name , Sur..

Ex: Column a - Mr. b. Jean c. Claud   -  if you put Mr J Claud then click Flash Fill then the succeeding rows will follow same result in row1.

 

هاشم المشارقة
by هاشم المشارقة , Key Account Manager , Advanced United Systems Ltd. ( A member of Taj Holding Group)

By dragging the left-bottom side corner of the upper cell.

Please see demo linked below:

https://support.office.com/en-us/article/Use-AutoFill-and-Flash-Fill-2e79a709-c814-4b27-8bc2-c4dc84d49464

Write Your Answer
More Questions Like This