0501 Go To (Special) - Formulas with Errors

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$195.60
You save:  A$55.89
List Price:  ৳11,872.36
You save:  ৳3,392.34
List Price:  CA$187.37
You save:  CA$53.54
CHF 91.26
List Price:  CHF 127.77
You save:  CHF 36.51
List Price:  kr884.75
You save:  kr252.80
List Price:  €118.74
You save:  €33.93
List Price:  £107.27
You save:  £30.65
List Price:  HK$1,084.99
You save:  HK$310.02
List Price:  ₹10,502.85
You save:  ₹3,001.03
List Price:  RM586.20
You save:  RM167.50
List Price:  ₦52,986.21
You save:  ₦15,140
List Price:  kr1,265.84
You save:  kr361.69
List Price:  NZ$211.96
You save:  NZ$60.56
List Price:  ₱6,870.27
You save:  ₱1,963.07
List Price:  ₨23,504.32
You save:  ₨6,716
List Price:  S$192.17
You save:  S$54.91
List Price:  ฿4,370.86
You save:  ฿1,248.90
List Price:  ₺1,021.10
You save:  ₺291.76
List Price:  R2,469.09
You save:  R705.50
Already have an account? Log In


Hi there. This session will talk about something very fascinating about one technique that is in Excel. And I've seen people really use it. And I'm sure that once you learn it, you will definitely love it and use it all the time in future. The question first, before us lies a data. And what I can see is a lot of errors thrown across in this data.

Now at the initial stages, what I want us to do is get rid of all these errors. Now if you want to proceed with the traditional method, the approach is going to be something like this, you select the cell containing the error and you deleted a minute, the data could be fairly large. So this can also lead to an erroneous step where you might delete the actual number. Also, alternatively, alternatively, instead of deleting these errors, you may want to color the cells containing the error. On the other hand, somebody might also ask you that If you are dealing the errors, instead of blank cell, I want a value which says pending data awaited from the client. Let's see how we do it quickly.

First, I'm going to choose the data set on the left. So I'm choosing the entire data set. pressing Ctrl G, yes, the shortcut key Ctrl G. Now it looks like a fairly simple box, but mind you, there is a button which is neatly hidden towards the bottom left corner. And you'll notice this button when you click upon special, you get multiple options. One of them might attract your attention and that is formula with errors. When you select this item, it says all the cells which contain formula and which is giving you error as an output will get selected and instantly you can eat these cells.

Not only that, since the cells are already holding their position they are already selected. You can go to Home tab and pick up your favorite color so that all the cells which we did right now gets highlighted Now mind you, in case in case you had proceeded with this approach, and you had gone to the special button formula with errors, you may have also deleted the data inside them. But before you go ahead and color do not do not Yes, I repeat, do not select the cell again and then go to color. Why? Because if you do that the entire set of selection gets lost and what you're ending up with is just one cell. So that was the starting point.

How do you get rid of all the errors in the particular excel sheet? Watch our next few videos to see how we fill all these blank cells with the word pending.

Sign Up