• Home  / 
  • Excel
  •  /  Go to Special – Excel Formula | Excel Shortcuts | Free online excel course

Go to Special – Excel Formula | Excel Shortcuts | Free online excel course

Go To Special – Excel Formula

Go to Special is very helpful when you know how to use it properly. See how can you use Go to Special Function.

If you are asked to perform a task where you have to replace all the cells where some formula has resulted in an error with a particular text or some colour. Editing each cell is going to take time and you might make mistakes while doing so manually.
Instead:

  1. Select the range of cells
  2. Press Ctrl + G
  3. Select Formulas with errors
  4. Now all such cells are selected
  5. You can perform any action on all these cells. It can be delete, or change colour or any.

Remember, not to select any cells further or else the above selection will be lost.

I hope you like our blog on Go to Special -Excel Formulas with Error, do share with your friend and colleague. If you wish to learn more about such smart tricks then try our Advanced Excel Tutorials or also check out our impressive Free Online Excel Course

Check out our E-Learning Video Courses
Also check out more related content available on our Youtube channel: Yoda learning Youtube Channel
While you do that also don’t forget to download our Excel Ninja App on Playstore so that you can learn excel on the go.

About the author

Yoda Learning Team

Yoda Learning Trainer team includes of 12 Industry experts focused on developing “Project-based" learning solutions, which enable the learners explore real world situations and thus, make the learning process engaging and practical. They have a collective work-experience of 80+ yrs.