Select noncontiguous ranges and visible cells only

- [Instructor] Often when you manipulate data in Excel,…you're using ranges of data, rectangular ranges.…You're highlighting data for example like this…making changes to all those cells…but there are times when you need to work with…noncontiguous data.…Now first example is rather small,…second example will be much larger but in both cases…we'll be talking about this idea of…working with non-adjacent or noncontiguous sets of data.…Imagine I'm about to make a presentation of this information…here, I want certain cells to stand out.…

I'm going to click on cell C4 and also I want to…click on cell E6.…Now before clicking here, I think a lot of you know…if I click on this cell and I'll do it for the moment…anyway, it will unselect C4.…There's no indication that I was ever there.…If I do this again, it's going to happen a third time,…but how do we select these different cells…at the same time?…We use the control key.…You might have seen this shortcut using formulas…in our first chapter.…I'm going to click on cell C4, hold down the control key now…