From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Select noncontiguous ranges and visible cells only

Select noncontiguous ranges and visible cells only

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Select noncontiguous ranges and visible cells only

- [Voiceover] When you're about to format data or hide data or copy or move it, many times you simply click and drag to select data, but there are times when you need to select data that's not adjacent to other data where you wanna perform the same function on. So, for example, I've got a list here. I'm ready to print it, but I've decided that some of the columns I really don't need as I print the data. So, I'm going to hide Columns D and E. By the way, when you zoom in and out sometimes in Excel, you will see pound signs. If you really need to see the data, drag across the columns, double click a boundary. It'll get the data back pretty quickly. But I don't want to see this data in the print out, so I'll drag across these two columns. I'm ready to hide those two columns, but I also want to hide, for example, Column I. So, I'll hold down the Control key and click Column I. I don't want to show the Job Rating, either. I'll click Column K. Right click on any of those column entries that…

Contents