How to Fill Intermittent Blank Cells in Excel

Learn: How to Fill Intermittent Blank Cells in Excel

Iss Video mai, me vo Shortcut Key discuss karne wala hu, jo maine Excel mai subse jyada use kia hoga.

Toh chaliye dosto mai aapko Problem batata hu:

Kabhi kabhi Data Points bichde hue hote hai, jaise ki:

  • Pehle(1st) ya Dusre(2nd) Column mai Naam ek(1) baar rahega
  • Unke saamne(against) Transactions bohot saare rehte hai
  • Aur dosto, jab tak aap Blank Cells ko Fill nahi karte sahi dhang se toh aap
    • Short
    • Filter
    • Pivot Table ki khubyo(features) ko use nahi kar payege.

Aap agar Numbers ko Copy+Paste karoge toh Numbers bhi Change hoge, toh Data Corrupt honeka bhi tension hai.

Toh dekhte hai dosto isse hum kaise bhare:

Taki Time utna he lage, jitna mai teen(3) naamo ko bharne mai laga raha hu ya teen hazar(3000) naamo ko,

  1. Affected Data ko choose kare jisme Blank Cells hai → Column A & B(numbers ko choose na kare)
  2. Press Ctrl+G(Go To), (Aur jankari k liye refer kare iss→Post ko)
  3. Press Special button → Choose Blank
  4. Press OK
    1. Waah Bhaiya, saare Blank cells Choose hogye.
  5. Sidha Equal to Key(=) Press kare
  6. Press kare Up Arrow(⇑) → Apne aap uppar waale Cell ko Choose karlega
  7. Press Ctrl + ENTER

Aree Waah bhaiya!, yaha toh saare Naam repeat hogye.

Me chahta tha ki saare Blank Cells apne Uppar waale cell ko Follow kare

Taki ek chain sa banjaye, agar vo chain banjaye toh saare Cells apne aap bhar jayege.

Toh issi Technique ko madhe nazar rakhte hue:

  • Isse Istamal jarur kijiyega
  • Isse Practice jarur kijiyega

Aur jaate jaate, ek chiz aur batauga:

Qki ye saare CellsFormula k basis pe khadda hai

Agar Pehla(1st) Cell Delete hojata hai?

Toh Dusre(2nd) Cell ko ye Zero(0) banadega

Toh dosto, iss prakriya ko khatam karne k liye aap ek chiz aur istamaal kare,

Jisska naam hai Paste Special Value:

  1. Pure Selection ko Select kare
  2. Copy kare
  3. Right Click kijiye uspe he → Paste Special → Value

Aur aap dekhege, ye saare banjayege Formula se Value.

Aur iske faide ye hai ki:

Agar aap koi Filter ya Sort karte ho, toh bade aasani se naam Filter hoke ajayege.

Toh dosto, isse Practice jarur kijiyega aur mujhe jarur batayega ki, aapko ye kaisa laga.

Humara bohot aise Excel Superstar Tricks hai, jarur dekhiyega.