Save time using the Flash Fill Function in Excel

Learn: Flash Fill Function in Excel

Ye Trick Excel 2013 version mai Introduce hua tha, aur ye Trick hai bohot Important.

Chaliye Dekhte hai ye kaam kaise karta hai:

Agar aapke pass Naam aur Surname iss tarah kuch diye gye hai ⇒

Aur aapko vo alag alag karne hai?

Aur Comma(,) k pehle jo chize hai vo aapko FN Column mai chaiye aur Comma(,) k baad LN Column mai?

  • Copy kijiye AbduSalaam ko FN Column mai
  • Copy kijiye Ismael ko LN Column mai

Abb ye chize mujhe subke liye karni hai:

Toh chaliye Dosto, dekhte hai ki kya Tarike hai Excel mai jisse mai ye kar sakta hu?

Dosto! Tarike bohot hoge, lekin Tarika vo use karna hai jo Excel Superstar karte hai.

Agar aap Excel 2103 use kar rahe hai?

  • Pehle Sample ko choose karte Last Sample tak chale jaaye
  • Aur ek Shortcut Key press kare Ctrl + E

Chaliye Dosto! mai aapko batata hu iska logic, aur ek example k dwara:

  • Ismael ko leke Last tak choose kijiye
  • Home Tab mai jaaiye
  • Right Side par Fill → Flash Fill(Ctrl+E) aayega jiska aap sahara le
  • Ya Fir Small Button ka bhisahara le sakte hai jo Cell par hai
  • Ya fir aap Ctrl + E press kijiye, qki hum hai Excel Superstar

Toh Dosto! Aise bohot saare Techniques hai jiske through Flash Fill aapki bohot madat kar sakta hai.

  • Note: Flash Fill ka Shortcut Key hai Ctrl + E
    1. Ctrl+E dabane se pehle aapko Ek Sample dikhana padega
    2. Choose karna padega
    3. Ek Column par fir Ctrl+E dabana padega

Chaliye mai kuch aur test karta hu:

  • Pehle Chaar(4) shabdo ko(Abdu) FN column mai daaliye
  • Ctrl + E Dabaiye
  • Aur ye aagya Result

Isme aur bohot saare logic hai jo mai aapko alag se video mai batauga.