Need Help? Chat with us

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:

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

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.

Learn 100+ Excel Tips & Tricks



“To be an Excel Superstar”



Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

Download ebook