Flash Fill | Automatically Fill blank cells with pattern | Excel Tutorial in Hindi - 19
Flash Fill is an intelligent feature of excel which can fill data with specific pattern.
Flash Fill allows you to fill a range of blank cells automatically with specific pattern. It can save your lot of time. It is one of the best smart feature of excel.
Flash Fill provides 3 most important functions-
1. Extract the data
It can extract small part of large data. For example, you can extract Street, City, State, Pin Code etc from Full Address.
2. Combine the data
It can combine many small data into one single entity. For example, you can combine Street, City, State, Pin Code fields into one field called Full Address.
3. Transform the data
Flash Fill can transform the lower case into upper case, proper case and vise versa.
So, it very important and smart feature of excel which allows you to work smartly and save a lot of time.
Previous video - • Fill, Series, Across Worksheets | Exc...
(Fill, Series, Across Worksheets)
Watch video Flash Fill | Automatically Fill blank cells with pattern | Excel Tutorial in Hindi - 19 online without registration, duration hours minute second in high quality. This video was added by user Excel & VBA Expert Online 03 December 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 17 once and liked it 1 people.