00:00So over here, you can see that I got some text and some blank spaces and some formula cells as well.
00:12If I want to go ahead and set up for contents, let's say, for example, blank cells right here,
00:18then what I can actually do is I can go to find and select right here. And then in find and select,
00:24you can see that go to special is an option. So here, what I can do is select blanks. Let's say
00:29for example, and if I were to press, okay, you can see that it actually highlights out the blanks
00:35that I have right here, just like this. So you can go around over here, go to special. And then
00:40if I were to select blanks right here, that these are highlighted. Similarly, if I were to go ahead
00:45and find and select and click on go to special, let's say, for example, I can go ahead and let's
00:52say, for example, add in formulas as well. So formulas with numbers, texts, logicals, and errors.
00:58If I were to press, okay, you can see it highlights these out right here. So similarly, let's say,
01:04for example, I can go around over here, uh, fine, go to special right here, and I can go ahead and
01:10let's say, for example, go around, uh, over here on to, uh, uh, let's say for example, last cell right
01:18here, or, uh, let's say blanks or a data validation right here. Then you can see that as, uh, as long as
01:26it is there, it'll actually show that. Let me just go ahead and then search for find and select,
01:33and then go to go to special right here and select out, let's say, for example, constants right here,
01:39press okay, and then it'll highlight out all the constant values right here. And that is how you can
01:44actually go ahead and then, uh, use the go to special right here. So if I were to actually select
01:50this, you can see that the selected cells right here now can be changed according to how I want.
01:55So that is how you can go ahead and utilize the go to special option inside of Microsoft Excel. So I
02:03hope you found this video useful. Be sure to hit the like button. Don't forget to share this out with
02:08your friends and family. And for more contents like these, do follow simple tutorials.