From the course: Excel: Tips and Tricks (2023)
Join today to access over 24,700 courses taught by industry experts.
Restore missing labels and hide repeating labels
From the course: Excel: Tips and Tricks (2023)
Restore missing labels and hide repeating labels
- [Instructor] We're looking at a list here and it was prepared for printing purposes. Rather than having the department names being repeated in column A, we only see the department name at the beginning of the department. It makes it easier to read. However, if we sort this data and let's keep an eye, for example, on Robert Allen who's in the ADC group, we're going to run into problems. It's all simply with the active cell somewhere in column B here. Do a quick A-Z sort. That's sorting alphabetically by way of the data tab. Here's the A-Z button. There it is. And look what's happened. His department names all seem to be pretty much clustered toward the top. And Robert Allen here, who was in the ADC group is now in the Operations group, looks like. We got a mess on our hands. Let's undo this with Control+Z and use what we might call a trick here. What we really want to do is to fill in all these with ADC and…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.