• 11 months ago
Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.

In this video lesson, we will learn about Using Go To Special in Microsoft Excel

You can access the entire Microsoft Excel Course in the following playlist:
https://www.dailymotion.com/playlist/xa9hywmicrosoft

Category

📚
Learning
Transcript
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.

Recommended