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
From the course: Excel 2016: Tips and Tricks
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.