Delete Cells easily by using Go To Special in Excel

Learn: Delete Cells easily by using Go To Special in Excel

Chaliye Dosto! Dekhte hai ye kaise kaam karta hai:

Iss Video mai hum dekhte hai ki, agar humare pass kuch aise Data Points hai

Jisme bohot saare Errors alag alag Cell mai bichde hue hai, jaise ki:

  • Unhe Delete kaise kare?
  • Unhe Colour kaise kare?
  • Unke baare mai kaise Pata Lagaye jaaye?
  • Vo Kidhar hai?

Yoh chaliye Dosto, hum batate hai aapko:

  1. Data Set ko Pura Choose kare
  2. Press Shortcut Key jo hai Ctrl + G
  3. G se aata hai Go To
  4. Click kare Special Button par
  5. Select kare Formulas par
  6. Numbers, Text & Logicals ko Deselect kardo
  7. Press OK

Waah Bhaiya! Jaha saare cells jisme Errors basse the, vo saare k saare Select ho chuke hai.

Abb agar aap TAB Key press karode toh:

  • Ek Ek Error Cells k uppar dodega
  • Aapko dikhega vo kidhar hai?
  • 1→2→3→4 Cells par jump karega

Abb Finally, agar aapko ye Cells nahi chaiye:

  • Press kijiye DEL

Waah! Sub Error Cells gayab.

Toh Dosto, aaj se hum use karege Ctrl + G Formula With Errors.

Aur aise he bohot saare Tricks humaare agle Video mai dekhte rahiyega.